Solved

ODBC Connection Error

Posted on 1998-12-09
4
1,400 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

770 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