We help IT Professionals succeed at work.

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

fippif asked
Medium Priority
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.

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
Make sure on your server you have a systemDSN for SQLOLEDB
Also have a look if u have ODBC driver installed for SQLOLEDB


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?



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.


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.