ODBC - connection to <name> failed (Error 3151)

Hi Everyone,

I have an MS Access 2003 question. I am trying to setup an ODBC connection on a client connecting to a SQL Srver database. I am getting the following errors "ODBC connection to file failed" Details are as follows--ODBC - connection to <name> failed. (Error 3151) The ODBC is accessed via a network connection but the connection to the server seems to be OK Any ideas or help would be very much appreciated.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Any firewall software installed on either machine? Are you connecting to a machine name or IP address?
Dr-CogAuthor Commented:
Hi zceororio, We, of course have a hardware firewall device on the lan. There is not a firewall of any kind, software or hardware, on the client. It is running Windows 2000 OS. This does not act like network connectivity issue as the error implies. It is most likely a database application type error. But then what do I know? That is why I have come to Experts exchange for tips and advice. I am not sure what I am missing here but I set up ODBC connections frequently and without any problems. My client's supervisor IS connected to the same database and without any issues. We are running SQL 2000 on the server where the database resides. We are connecting to the host name not the IP address. Both forward and reverse are resolved so DNS is not an issue I don't think. My client's supervisor is also running Windows 2000 OS and both are running MS Office 2003. The application is MS Access 2003. Anyway I hope this is enough information to rule out some common issues. Thanks for your help out there.  
Dr-CogAuthor Commented:
Machine name
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Dr-CogAuthor Commented:
Thanks solved it Have a good day
Dr-CogAuthor Commented:
Hi All

Thanks for your suggestions. It turned out that the default database on the ODBC setup was not configured. It had nothing to do with a firewall as it is an internal connection. Thanks all until next time.
PAQed with points refunded (500)

EE Admin

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
I have the same problem- ODBC - connection to <name> failed. (Error 3151)
Can you please explain how did you solve it exactly
Om JoshiSr. System AdministratorCommented:
Hi Dr-cog,

i am also having similar issue with ODBC connection. I believe it times out and looses the connection.

My issue comes from a software when it tries to cross check database entries while fetching and checking software throws 3151 ODBC connection failed error.

i would really appreciate if you could share your solution on the website.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.