Solved

ODBC Connection Error

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
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…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

929 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

8 Experts available now in Live!

Get 1:1 Help Now