TestConnectivity returns true on dev machine but false on test machine

[Former Member]

Hello,

I have a SQLServer 2005 database on a client server. I have a VPN connection to their server. I am using the connection code from [here|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_dev/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes.do]

When I run the app from my local dev machine it works fine, reports display things are great. When I run the app from testing machine it fails. I have followed the trail and found out that it fails on the TestConnectivity method. This occurs despite the fact that I haven't changed anything in the code.

I am using the same VPN information, and I know that I can access the database from that machine. The clients also have trouble with it and they are on the same network.

I am using Windows XP SP3 for both PC's

Does anyone have any idea's?

Nathan

[Former Member · Accepted solution]

Hi,

By any chance you are using SQL native client to sonnect to SQL Server?

If yes make sure you have the SQL native client driver on client machine as well

Thanks,

Prasad Kanchan