Solved

ODBC Connection Error

Posted on 1998-12-09
4
1,401 Views
Last Modified: 2012-05-04
I receive this error when connecting my vb app to SQL.
"40002. 01000: [Microsoft][ODBC SQL Server][dbnmpntw]ConnectionOpen[CreateFile[]]"
Help anyone?
0
Comment
Question by:Yogi012398
  • 2
  • 2
4 Comments
 

Accepted Solution

by:
byike earned 50 total points
ID: 1092186
I experienced this problem today as well. It was resolved by changing the ODBC configuration on the client. The entry I changed was in the 'Server' section of  the 'ODBC SQL Server Setup' dialog.

My original entry was '\\MyDbServer' (without the quotes) - where MyDbServer is the network name of the machine that SQL Server resides on.

I changed it to 'MyDbServer' and the error disappeared. If that's not it, I would first verify that the other entries in the  'ODBC SQL Server Setup' dialog are correct.
0
 

Author Comment

by:Yogi012398
ID: 1092187
I still get the same error. Is there any way you could give me a screen shot of the server odbc setup for sql and the client odbc setup for sql to see if I am missing anything or do you have any other suggestions? Thanks.
0
 

Expert Comment

by:byike
ID: 1092188
No problem. What is your e-mail address?
0
 

Author Comment

by:Yogi012398
ID: 1092189
josht@vcon.com
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSRS - Date Report Options 2 28
SQL Query 2 31
SQL Group By Question 4 19
Help With SQL Query 9 30
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

856 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