>Hi all,
>I'm having a tough time solving an issue and hope the experts around here can help.
>
>I've written a small VFP9 exe that connects to SQL Server 2005 using SQLSTRINGCONNECT(). Running it from the VFP command window, it works like a charm. I run the exact same EXE from Windows explorer and an MS SQL Server Login error displays, Connection failed... etc. I have tried many different things to resolve this but just can't seem to solve it.
>
>I am using an ODBC connection.
>
>It seems to be a permissions issue but I just can't figure why the VFP IDE would have no problem but the standalone exe does.
Have you tried right-clicking on your EXE in Windows Explorer and running it as an Administrator?
What authentication mode are you using for SQL Server - Windows or SQL Server?
What is the exact error you're getting?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up