I have an ISP who is currently hosting a MS-SQL database for me on the Internet. I have been able to connect to the database through an ODBC connection on a Windows NT workstation.
Now I am trying to connect to that same database from several other computers and on each computer I get the error message - "Connection failed: SQLState: '01000' SQL Server Error: 53 [Microsoft][ODBC SQL Sever Driver][dpnmpntw]Connection Open (CreateFile()). Connection failed: SQLState: '08001' SQL Server Error: 53 [Microsoft][ODBC SQL Sever Driver][dpnmpntw]Connection Open (CreateFile())." And I cannot get a successfull connection to the database.
On each computer, including the one that works, I am using a dial-up connection to the Internet. On each computer I can successfully ping the SQL Server, before trying to connect with ODBC. And on each computer I am using Microsoft Access to try and link the tables from the database.
Is there some piece of the setup that I am missing on the other computers? Does my ISP need to make a configuration change on their SQL Server to accomodate connections from these other computers? I am not sure what else to try.