ODBC Connection Error

I receive this error when connecting my vb app to SQL.
"40002. 01000: [Microsoft][ODBC SQL Server][dbnmpntw]ConnectionOpen[CreateFile[]]"
Help anyone?
Who is Participating?
byikeConnect With a Mentor Commented:
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.
Yogi012398Author Commented:
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.
No problem. What is your e-mail address?
Yogi012398Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.