Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 13620
  • Last Modified:

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

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.

2 Solutions
Probably, the driver is not installed on the target machine.  Make sure that the driver is installed and try again.
Make sure on your server you have a systemDSN for SQLOLEDB
Also have a look if u have ODBC driver installed for SQLOLEDB
fippifAuthor 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?

fippifAuthor 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.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now