I have a VB program to update a distant SQL Server database. The database is located at my web host, MaximumASP.
It works fine on my computer and several others around, but on machines in another network I get the following error when trying to open the connection:
[Microsoft][ODBC SQL Server Driver][Named Pipes]Access
Here's the very simple code for opening the connection:
strConnString = "DRIVER=SQL Server;SERVER=maxsql002.maximumasp.com;UID=uid;PWD=pwd;"
Set db = New Connection
db.ConnectionString = strConnString
db.CursorLocation = adUseClient
It's probably some configuration issues with the second network, but I really don't know where to look...