Data source name not found and no default driver specified

Help!!
I can connect fine to my Db from my test server at home but when I move it to my server (my web server and SQL server are on the same machine) I get the following error:

Microsoft OLE DB Provider for Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Can someone please lend a hand. Thanks!

How are you connecting to the DB on the production server? DSN, DSN-less? If DSN, is the DSN setup correctly on the live server? If DSN-less, is the driver present? Does the live DB server have the same name, db??

it's connecting to a server DNS.

fix:

Delete the USER data source name and define it as a SYSTEM data source name.

In Windows 2000:
-> Start -> Settings -> Control Panel -> Administrative Tools ->
Data Sources (ODBC):
- User DSN : delete the specified User DSN
- System DSN : create a new System DSN

Hi there.

What's the fix when using a non-DSN connection?

Thanks in advance,
another Newbie

Sounds like you have a bad connection string - show us what you've got and we should be able to help you.
Alternatively, this resource should be able to get you going: http://www.carlprothman.net/Default.aspx?tabid=81

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I had this error and want to let you know how it was resolved.

First, this was an ASP web application using a vb 6.0 dll to get data from a sql server 2005 database on a 64 bit windows server 2008 enterprise (vista like) server. I could only get the dll to work in component services as opposed to simply registering it.

It all worked fine upon setup, but after four windows updates one night, the error above was posted in the event viewer, and the web app crashed.

Here is the resolution:

In a 64 bit windows server operating system, there are TWO odbc managers. When you pull up the usual menu for the odbc / dsn system, it is for the 64 bit odbc manager, and 32 bit applications (vb 6.0) will not work using these dsn's.

This is where the 32 bit odbc manager is:

C:\Windows\SysWOW64\odbcad32.exe

I hope you do not have to go through what I and three Microsoft Support engineers had to to figure this out.

Jonathan