Problem in using MSDASQL (ODBC) provider

From: Ganga Sridhar (gangasridhar_at_abosoftware.com)
Date: 08/03/04

  • Next message: drew: "odbcad32.exe displays badly" 
    Date: Tue, 3 Aug 2004 22:37:06 +0530

    Platform : WindowsXP, MSAccess2000, MDAC2.5

    Hello,
    A client of ours is facing a problem when the following code is getting
    executed on his system
    HRESULT hr;
    // Create an instance of the MSDASQL (ODBC) provider
     hr = CoCreateInstance(CLSID_MSDASQL, NULL, CLSCTX_INPROC_SERVER,
            IID_IDBInitialize, (void**)ppIDBInitialize);
    The HRESULT returned is -2147024769
    Our application uses certain System DSNs created in ODBC manager to connect
    to our databases.
    The only problem I am able to suspect on the user's system is that probably
    his ODBC drivers are not properly installed or registered. Are there any
    other suggestions as to what could be the problem?

    We tried reinstalling MDAC2.8 and reinstalling MSAccess on his system but
    still the problem persists. We learnt from Microsoft site that ODBC driver
    don't get updated in MDAC2.8.Also MDAC2.5 does not get installed on the
    WindowsXP system as it is detected to be installed already. Is there any
    separate redistributable available that would install the ODBC drivers and
    register them on the client system? Any pointers or suggestions would be of
    great help.

    Thanks and Regards
    Ganga

  • Next message: drew: "odbcad32.exe displays badly"

    Relevant Pages

    • RE: Problem in using MSDASQL (ODBC) provider
      ... install Ms Jet 4.0 SP8 for WinXP and try again... ... > A client of ours is facing a problem when the following code is getting ... > his ODBC drivers are not properly installed or registered. ...
      (microsoft.public.data.odbc)
    • Setting up the DBD::ODBC module
      ... I then also installed the Perl DBI. ... test and install Perl 5 ... some Paradox ODBC drivers *could* fail, ...
      (perl.beginners)
    • Instaling DBI 1.42 on Mac OS X Server version 10.2.4 I
      ... -1 after entering the command: Perl Makefile.PL I have obtained the following ... The DBD::ODBC module needs to link with an ODBC 'Driver Manager'. ... (The Driver Manager, in turn, needs one or more database specific ODBC drivers. ... I want to know what I should in order to resolve the problem and to install ...
      (perl.dbi.users)
    • Re: Install SQL server 2000
      ... Sounds like you are missing your ODBC drivers. ... So I uninstall sql server and install it again. ...
      (microsoft.public.sqlserver.setup)
    • ODBC Connection Error
      ... I recently updated a client application to Clarion 6.3 build 9053. ... Topspeed ODBC drivers and is getting the following error: ... He had no problem connectin before the update. ...
      (comp.lang.clarion)