Tuesday, May 9, 2023

Crystal Report Runtime Installation Error 1935

Open your registry editor, find 

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control

Create Or Change (if exist)  RegistrySizeLimit's(REG_DWORD) value to “FFFFFFFF”

And Restart PC. (Without restart changes will not work)


Friday, April 14, 2023

Hello Everyone,

I am excited to offer my Visual FoxPro Project Maintenance/Updation Service. I can work with any version of the Visual FoxPro and provide the following features:

* Identify and fix any programming bugs in your applications.

* Upgrade your applications to .Net projects.

* Seamlessly migrate your Visual FoxPro's native database to other databases, such as SQL Server, MySQL, PostgreSQL, and more.

* Facilitate the migration of your database to the cloud, making it easily accessible for remote work via the Internet.

I am confident that my expertise in Visual FoxPro will add value to your business operations, and I look forward to working with you.


for more information contact

Skype: kalpesh2804

email : kalpesh@kalpesh.biz, kalpesh2804@yahoo.com

WhatsApp: +91 98 98 29 62 36

#VisualFoxPro #VisualFoxProSupport #FoxProDeveloper #FoxPro #FoxProSupport

Friday, November 8, 2019

Send Ctrl-Alt-Del to nested RDP session


eg.
PC - A  = Its your Own Computer
PC - B  = RDP  PC - 1
PC - C =  RDP PC - 2 (Inside RDP PC1)

Here's the scenario: I Remote Desktop from Computer A to Computer B and from Computer B to Computer C.

(1) I want to send Ctrl+Alt+Del to Computer A, I type Ctrl+Alt+Del from Computer A

(2)  want to send Ctrl+Alt+Del to Computer B, I type Ctrl+Alt+End  inside Computer B

(3) If I want to send Ctrl+Alt+Del to Computer C, I open the On-Screen Keyboard on Computer C and use it to type Ctrl+Alt+End, which sends Ctrl+Alt+Del to Computer C

OR  

If I want to send Ctrl+Alt+Del to Computer C, I type Shift+Ctrl+Alt+End  inside Computer C.


Change Database default locations in SQL Server

Method 1: Change default database location via SQL Server Management Studio (SSMS):
Step 1. Right Click on Server and Select "Properties".



Step 2. in the "Server Properties" dialog box, navigate to "Database Settings" tab and data/log files location under "Database default locations" group.


 Step 3.  Click on "OK" to Save Changes.

Step 4.   As per Microsoft SQL Server Instance need to restart for to take effect. so Right Click on Server and Click on "Restart". It will prompt for confirmation - Press Yes. You can Restart Server Instance using Services.msc


Tuesday, October 11, 2016

Create Shortcut with RunAs Administrator using VFP


Create Shortcut with RunAs Administrator using Visual FoxPro Code.

Function CreateShortcut
Lparameters lcExecutableFile,lcShortcutText,lcProgramDesc,llRunAsAdmin

lcTmpShortCutFile  = Addbs(Getenv("TEMP")) + Sys(2015)+".lnk"

oWsh = Createobject("wscript.shell")
cDeskpath = oWsh.SpecialFolders("desktop")

lcShortcutFile = cDeskpath+"\"+lcShortcutText+".lnk"
If llRunAsAdmin
oShort = oWsh.CreateShortcut(lcTmpShortCutFile)
Else
oShort = oWsh.CreateShortcut(lcShortcutFile)
Endif

oShort.TargetPath = lcExecutableFile
oShort.WorkingDirectory = Addbs(Justpath(lcExecutableFile))
oShort.Description = lcProgramDesc
oShort.Save

If llRunAsAdmin && Creating New Shortcut with RunAs option.

nhandle     = Fopen(lcTmpShortCutFile)
nFilesize     = Fseek(nhandle,0,2)
=Fclose(nhandle)
nhandle     = Fopen(lcTmpShortCutFile)

nHandle2     =  Fcreate(lcShortcutFile)
If nhandle     = -1  &&OR nHandle2 = -1
Wait Window [both source and destination files must be accessible]
=Fclose(nhandle)
=Fclose(nHandle2)
Return
Endif

nRemain     = nFilesize
i = 0
Do While !Feof(nhandle)
nChunk     = 1 && MIN(100,nRemain)
cTake     = Fread(nhandle,nChunk)

If i=21
cTake = Chr(32)  && a[0x15] |= 0x20; // flip the bit.  for RunAsAdmin
Endif

=Fwrite(nHandle2,cTake,nChunk)
nRemain = nRemain - nChunk

i = i + 1
If nRemain = 0
Exit
Endif
Enddo
=Fclose(nhandle)
=Fclose(nHandle2)

Delete File "&lcTmpShortCutFile"
Endif
Return

Saturday, March 22, 2014

Class Library Toolbox Icon

Step 1: 

Create bmp file (16x16) and save as like below.

   ProjectNameSpace.ControlName.bmp

  e.g. Project Name : CustomGrid
        Control Name : MyGridControl

Bmp File Name :  CustomGrid.MyGridControl.bmp

Step 2: Add in Project and Change Build Action Properties to "Embedded Resources".

Stpe 3: Add ToolboxBitmap line in your class file as per screenshot.




Step 4 : Compile your Project as "Class Library".

Step 5:  Add this control in Different Solution Project Toolbox using choose items and icon will display like below ( In Same Project icon can not display).


Download Complete Source : CustomGrid.Zip



Wednesday, May 1, 2013

x86 and x64 Bit Dll Issue


Only use the x86 DLL and make sure that the application build platform is x86 and the platform target is x86, because the 64 bit can run the x86 normally.
 To find those you should go to the application properties, and then at the build  tab you'll find them.
To Create new platform with x86, you have to locate the platform combo box beside the "Start Debugging" or "Play" or "RUN" button, and select the "configuration manager" from it.
Hope this will help.

Wednesday, January 2, 2013

Capture Screen with Menu

This Application will capture screen with Open Menu. (e.g. File Menu, Windows Start Menu)

It will works with Windows 7 Basic Themes & Aero Themes.

Wednesday, December 7, 2011

How do you run a 300mb+ MS SQL .sql file?

From the command prompt, start up sqlcmd:

sqlcmd -S <server> -i C:\<your file here>.sql -o
Just replace with the location of your SQL box and with the name of your script. Don't forget if you're using a SQL instance the syntax is:
Here is the list of all arguments you can pass sqlcmd:
Sqlcmd            [-U login id]          [-P password]
  [-S server]            [-H hostname]          [-E trusted connection]
  [-d use database name] [-l login timeout]     [-t query timeout] 
  [-h headers]           [-s colseparator]      [-w screen width]
  [-a packetsize]        [-e echo input]        [-I Enable Quoted Identifiers]
  [-c cmdend]            [-L[c] list servers[clean output]]
  [-q "cmdline query"]   [-Q "cmdline query" and exit] 
  [-m errorlevel]        [-V severitylevel]     [-W remove trailing spaces]
  [-u unicode output]    [-r[0|1] msgs to stderr]
  [-i inputfile]         [-o outputfile]        [-z new password]
  [-f  | i:[,o:]] [-Z new password and exit] 
  [-k[1|2] remove[replace] control characters]
  [-y variable length type display width]
  [-Y fixed length type display width]
  [-p[1] print statistics[colon format]]
  [-R use client regional setting]
  [-b On error batch abort]
  [-v var = "value"...]  [-A dedicated admin connection]
  [-X[1] disable commands, startup script, enviroment variables [and exit]]
  [-x disable variable substitution]
  [-? show syntax summary]