>Re-working a VFP app to run as a Service. Just run out of ideas on getting SQLConnect() to work as a service. Not only do I not connect it hangs on this command. I have very good logging that tells me where I am at in the code to show me it IS hanging.
>
>Connects to the SQL Server at the VFP prompt using Windows Authentification. (Use SQL Connect String being logged in log file)
>Connects to the SQL Server at the VFP prompt using SQL Server Admin Account. (Use SQL Connect String being logged in log file)
>
>
>Connects to the SQL Server doing the SQLConnect() within the same App.
>
>But just will not connect when attempting login when run as a service using any of the above methods (with proper cSQL modifications of course)

The account your service is running under needs to have permission to connect to SQL Server. You can either give explicit permission to this account, or change the account the service runs under to one that has access, or use SQL authentication instead of Windows Authentication.