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

Posted on 2009-02-16
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.

Question by:fippif
    LVL 12

    Accepted Solution

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

    Assisted Solution

    Make sure on your server you have a systemDSN for SQLOLEDB
    Also have a look if u have ODBC driver installed for SQLOLEDB

    Author Comment

    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?


    Author Comment

    I realized I have the driver. Installed and corrected this problem. Thx.

    Expert Comment

    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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    MySQL 11 47
    How does Google get such fast response times? 5 70
    DNS issue 6 33
    Text in tooltip bound field bridview 3 17
    I've written instructions for one router type, but this principle may be useful for others of the same brand and even other brands of router. Problem: I had an issue especially with mobile devices that refused to use DNS information supplied via…
    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now