VFP SQL Connection Failing When Compiled into the .EXE

[stanlyn]

Hi,

This SPT code works fine while within vfp9, however it asks for credentials after being compiled into an exe. The connection string is intentionally embedded into the exe. What needs to be done for it to work in an exe without any prompts as this runs headless?

lcDSNLess = "Driver={SQL Server}; Server=zzzDAS; UId=sa; Pwd=passw"
gnConnectionHandle = Sqlstringconnect((lcDSNLess), .T.)

Thanks for your help,
Stanley Barnett

 

[stanlyn]

OK, the 20 second delay is somehow caused by the firewall, as with the top Domain section disabled it is instant. When turned on, it takes 20 seconds.

Both servers are on same domain and lan. The user running the vfp exe is a domain user like "domain\user". Any other OS or SQL perms I need to look at or grant?

Thanks, Stanley