Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLStringConnect() - working as .app, not as .exe
Message
From
04/07/2009 12:56:31
 
 
To
04/07/2009 06:33:40
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01410028
Message ID:
01410065
Views:
60
>>I've been testing an application that involves connectivity to SQL Server. When the application is compiled as an .app file and run inside VFP, connections initiated by SQLStringConnect() work just fine. However, when the application is compiled as an .exe file and run independently, after stalling for a long time, the attempt to connect fails.
>>
>>I'm stymied...
>
>I agree with Cetin's comment. FWIW, you can use AError() to determine error numbers/messages when any Vfp SQL*() function fails, it's useful for unsuccessful SqlExec() lines as well as failing SQLStringConnect() etc.

According to AError(), the connection attempt is timing out, which I suspected intuitively. The connection string looks correct, and when I switch back to compiling the application as an .app, it continues to work correctly. Most of the research I've done indicates that there's something going on at the server end, but that doesn't make sense in the context.

Any thoughts?
David M. Stowell
Ravenslake Consulting
Chicago, Illinois

e-mail: davidstowell@ravenslakeconsulting.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform