?
Solved

ODBC Connection Error

Posted on 1998-12-09
4
Medium Priority
?
1,409 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 

Accepted Solution

by:
byike earned 100 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.
Suggested Courses

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