>Hi,
>
>I have a weird one that's been bugging me for a couple days now and I cannot come up with a solution.
>
>Client has 6 PCs. 4 running Windows XP , 1 on Windows 7 and one on Windows 8.1.
>
>I have installed my VFP app on all and all are able to connect to a SQL Server database on a server except 1 XP PC.
>
>I can use the ODBC administrator to create a connection and test the connection successfully, but my application which uses a connection string and code like this:
>
>m.lnHandle = SQLSTRINGCONNECT(m.lcConnectionString,.T.) &&& 2nd parameter as .T., as the single-connection-per user, shared by remote views
>
>always sets m.lnHandle to a negative number.
>
>I have copied the file with the connection string from a working PC.
>
>I have created a very simple application which just tries to connect using the connection string and it fails too.
>
>Does anyone have any ideas? In over 100 installs similar to this I have never been able to use ODBC admin successfully and not my code.
What is the result from that:
m.lnHandle = SQLSTRINGCONNECT(m.lcConnectionString)
IF m.lnHandle < 0
AERROR(laError)
MessageBox(laError[1,2])
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.