Solved

ODBC Connection Failed

Posted on 1998-03-28
13
442 Views
Last Modified: 2008-02-01
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.
0
Comment
Question by:alc
  • 5
  • 5
  • 2
  • +1
13 Comments
 
LVL 1

Expert Comment

by:sivabalan
ID: 1090901
Hi,
I think this is because of the ODBC connections that are left open and are not disconnected. One thing you can do is try freeing all the open connections(say by restarting the server) or you can increase the number of user connections in the server manager window of the SQL Server Enterprise Manager. From next time be sure to close an ODBC connection once the operation is over. Hope this helps.
0
 

Author Comment

by:alc
ID: 1090902
This doesn't explain why I could get an ODBC connection on one machine and not another.
0
 
LVL 1

Expert Comment

by:sivabalan
ID: 1090903
Hi,
Maybe the connection from that particular m/c may be already open due to which it connects from that m/c. You can check this out by restarting the server. If I had wrongly understood the scenario please do throw some light on it.
0
 
LVL 2

Expert Comment

by:egono
ID: 1090904
Do you set a system DSN in the ODBC manager on the other
machines (which dont work) ? Compare these settings with the
working machine.

0
 

Author Comment

by:alc
ID: 1090905
sivabalan, I will have to get my ISP to restart the server in order to try this out since the server is not within my control. But I only connect to the server occasionally. If for some reason I had not closed the connection from the working machine wouldn't the connection time out after a period of time?

egono, Yes I have set all the DSN's up as system DSN's. I have checked all of them several times and I cannot find any difference between the working one and the one's that don't work.

Something else that I have tried is to logon locally to the machine that is working and try connecting. This way my domain is now the local machine rather than the network. I found that I received same error message that I got on all the other machines. It would seem that the perhaps the domain is causing the connection problem.
0
 
LVL 5

Expert Comment

by:perezjos
ID: 1090906
When you setup a connection with a MS-SQL server you need to setup the protocol to connect to the server. On the Client, you are able to setup a protocol as TCPIP or named pipes.
Use TCPIP if possible or set your workstation to use trusted connections.
Then your ODBC driver will connect to the remote server using the protocol you defined.
Good Luck
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 5

Expert Comment

by:perezjos
ID: 1090907
you can also use ODBCPING.EXE to check your connection to the sql server.
0
 

Author Comment

by:alc
ID: 1090908
Well I finally got the problem solved by calling Microsoft Tech. Support. Perezjos had the right idea. I was using the default network library which was named pipes, but that protocol is not very reliable over a TCP/IP WAN like the Internet. Instead I needed to use the sockets library dbmssocn.dll. Thanks for your help.
0
 

Author Comment

by:alc
ID: 1090909
I will award the points to perezjos.
0
 
LVL 5

Expert Comment

by:perezjos
ID: 1090910
Thank you
0
 
LVL 5

Expert Comment

by:perezjos
ID: 1090911
thank you
0
 

Author Comment

by:alc
ID: 1090912
Perezjos, I think you need to submit an answer message in order for me to grade your message.
0
 
LVL 5

Accepted Solution

by:
perezjos earned 200 total points
ID: 1090913
Thanks for your comments. I hope it will do this time.




0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now