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)
I do have DisplayWarnings Turned off as well as DisplayLogin.
cSQL = 'SQL Connect String: Driver=SQL Server;Server=FWTXS8;UID=;PWD=;Trusted_Connection=Yes;Database=MCS_309'
What ben makes tracks for what wil be. Words in the air pirnt foot steps on the groun for us to put our feet in to.
Riddley Walker