We help IT Professionals succeed at work.

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

fippif
fippif asked
on
Medium Priority
13,964 Views
Last Modified: 2013-12-25
I use Odbc to run a query against a progress database. Here is the connection string:
Provider=SQLOLEDB;DRIVER=Progress OpenEdge 10.1A driver; HOST=hostName;PORT=XXXX;DB=dbName;UID=XXX;PWD=XXX;

This works fine on my PC. But when I deploy to the server, I get the following error:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[OdbcException (0x80131937): ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
   System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +35
   System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) +131
   System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +98
   System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.Odbc.OdbcConnection.Open() +37
   webform1.Page_Load(Object sender, EventArgs e) in c:\Documents and Settings\atabrizi\My Documents\Visual Studio 2005\Projects\Dacor.ServiceInvoice\Web\Service Invoice\webform1.aspx.cs:21
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436



I am not sure how to approach a solution.


Thanks.
Comment
Watch Question

Probably, the driver is not installed on the target machine.  Make sure that the driver is installed and try again.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Commented:
Make sure on your server you have a systemDSN for SQLOLEDB
Also have a look if u have ODBC driver installed for SQLOLEDB

Author

Commented:
how can I determine whether these drivers are installed? Can I download them from the web? Or would I need the CD?
How do I check the systemDSN for SQLOLEDB?

Thx.

Author

Commented:
I realized I have the driver. Installed and corrected this problem. Thx.
I am working with a remote user getting this error. This person is not directly associated with my company so I really don't know what's on their computer. If I try and have them add the ms access driver, will they be prompted for a CD? Is it likely that adding this will cause any other issues? What I am really talking about is a common, well know isssue, not the once in a blue moon type.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.