>>>>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.
>>>>
>>>>Ideas?
>>>>Thanks,
>>>>Ed
>>>
>>>Where do you have the EXE installed (directory path)? Is is on the same machine as the IDE?
>>
>>Hi Hank,
>>I have it in a separate folder, but I have already tried it in the VFP program directory, same problem.
>>Thanks for responding.
>My question was about the path. Have you tried installing it on something like c:\myapp?

Sorry Hank... I wasn't very clear. I had it on a network drive, then I tried it in c:\myapp. I can now confirm that it works in c:\myapp only when the config.fpw file is deleted. I even tried it right inside the VFP directory... same story, with config.fpw it doesn't work, without config.fpw, it works.