>>>>>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
>>>>
>>>
>>>Boris,
>>>
>>>(it's deja vu all over again!) ;)
>>>
>>>I got it!
>>>
>>>It turns out they had McAfee running on this PC (which should not have been). I uninstalled it and can now connect, so I guess that must have had the firewall on and was blocking my program.
>>
>>You probably could've added your program to the exceptions list rather than simply turning off the antivirus/firewall.
>
>Thanks, but McAfee was not supposed to be there so I needed to uninstall it anyhow.
So was it a "piggyback install" item (i.e. was installed in the course of downloading/installing a completely unrelated product) ?