Oracle ODBC connection problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • SerGioGio
    #1

    Oracle ODBC connection problem

    Hello,

    I am going nuts. I am trying to connect to my local ORACLE instance using
    ODBC.
    It used to work few weeks ago, but it fails now.

    Connection with:
    - SQL*plus: connection works!
    - DataDirect 5.0 Oracle Wire protocol (3rd party ODBC driver): connection
    works when I hit the driver's "test connection"
    but not anymore in real case scenario (using th DSN from an application).
    - Oracle ODBC driver 9.02.00.05: connection does not work when I hit the
    driver's "test connection", I get:
    Unable to connect
    SQLState=IM004
    [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV
    failed
    - Microsoft ODBC for Oracle 2.575.1022.00: cannot even configure the ODBC
    data source, always get:
    The Oracle(tm) client and networking components were not found.
    These components are sypplied by Oracle Corporation and are part
    of the Oracle Version 7.3 (or greater) client software installation.
    You will be unable to use this driver until these components have been
    installed.

    I am running Oracle version 9.2.0.1.0 on an xp Home Computer SP1 FAT32, and
    trying to use ODBC on the same computer. I installed the Oracle client
    version 9.2.0.5 to solve the problem but it did not work. I searched the
    newsgroup for the error messages but could not find any solution solving my
    problem - I do not think it is a permission problem on a registry or on a
    file system directory. I also installed the latest MDAC with no success.

    This used to work but does not anymore!! I do not know how/when/why it got
    corrupted. Does anyone have any clue on what could be going on here?

    Thanks in advance for your help,

    Regards,

    SerGioGio


    Tags: None
    • sybrandb@yahoo.com
      #2
      Re: Oracle ODBC connection problem

      "SerGioGio" <sergiogio@yaho o.frwrote in message news:<414fca4e$ 1@news.starhub. net.sg>...
      Hello,
      >
      I am going nuts. I am trying to connect to my local ORACLE instance using
      ODBC.
      It used to work few weeks ago, but it fails now.
      >
      Connection with:
      - SQL*plus: connection works!
      - DataDirect 5.0 Oracle Wire protocol (3rd party ODBC driver): connection
      works when I hit the driver's "test connection"
      but not anymore in real case scenario (using th DSN from an application).
      - Oracle ODBC driver 9.02.00.05: connection does not work when I hit the
      driver's "test connection", I get:
      Unable to connect
      SQLState=IM004
      [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV
      failed
      - Microsoft ODBC for Oracle 2.575.1022.00: cannot even configure the ODBC
      data source, always get:
      The Oracle(tm) client and networking components were not found.
      These components are sypplied by Oracle Corporation and are part
      of the Oracle Version 7.3 (or greater) client software installation.
      You will be unable to use this driver until these components have been
      installed.
      >
      I am running Oracle version 9.2.0.1.0 on an xp Home Computer SP1 FAT32, and
      trying to use ODBC on the same computer. I installed the Oracle client
      version 9.2.0.5 to solve the problem but it did not work. I searched the
      newsgroup for the error messages but could not find any solution solving my
      problem - I do not think it is a permission problem on a registry or on a
      file system directory. I also installed the latest MDAC with no success.
      >
      This used to work but does not anymore!! I do not know how/when/why it got
      corrupted. Does anyone have any clue on what could be going on here?
      >
      Thanks in advance for your help,
      >
      Regards,
      >
      SerGioGio
      This version of the Microsoft driver has the location and the name of
      the DLL hardcoded.
      Consequently it won't work on any version other than 7.3
      Oracle 9i is not certified against and support on XP Home.

      Sybrand Bakker
      Senior Oracle DBA

        Comment

        • Yukonkid
          #3
          Re: Oracle ODBC connection problem

          "SerGioGio" <sergiogio@yaho o.frwrote in message news:<414fca4e$ 1@news.starhub. net.sg>...
          Hello,
          >
          I am going nuts. I am trying to connect to my local ORACLE instance using
          ODBC.
          It used to work few weeks ago, but it fails now.
          >
          Connection with:
          - SQL*plus: connection works!
          - DataDirect 5.0 Oracle Wire protocol (3rd party ODBC driver): connection
          works when I hit the driver's "test connection"
          but not anymore in real case scenario (using th DSN from an application).
          - Oracle ODBC driver 9.02.00.05: connection does not work when I hit the
          driver's "test connection", I get:
          Unable to connect
          SQLState=IM004
          [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV
          failed
          - Microsoft ODBC for Oracle 2.575.1022.00: cannot even configure the ODBC
          data source, always get:
          The Oracle(tm) client and networking components were not found.
          These components are sypplied by Oracle Corporation and are part
          of the Oracle Version 7.3 (or greater) client software installation.
          You will be unable to use this driver until these components have been
          installed.
          >
          I am running Oracle version 9.2.0.1.0 on an xp Home Computer SP1 FAT32, and
          trying to use ODBC on the same computer. I installed the Oracle client
          version 9.2.0.5 to solve the problem but it did not work. I searched the
          newsgroup for the error messages but could not find any solution solving my
          problem - I do not think it is a permission problem on a registry or on a
          file system directory. I also installed the latest MDAC with no success.
          >
          This used to work but does not anymore!! I do not know how/when/why it got
          corrupted. Does anyone have any clue on what could be going on here?
          >
          Thanks in advance for your help,
          >
          Regards,
          >
          SerGioGio
          Hi,

          2 recommendations :

          * check PATH setting on your Windows if the ORACLE_HOME containing the
          ODBC DLLs is listed first
          * Set your ORACLE_HOME explicit with "Oracle home selector" (should be
          available under the menu 'Oracle installation products'

          yk

            Comment

            • Michael D. Long
              #4
              Re: Oracle ODBC connection problem

              <sybrandb@yahoo .comwrote in message
              news:a1d154f4.0 409210316.3aef6 df0@posting.goo gle.com...
              >
              This version of the Microsoft driver has the location and the name of
              the DLL hardcoded.
              Consequently it won't work on any version other than 7.3
              Oracle 9i is not certified against and support on XP Home.
              Actually, this isn't correct. The latest shipping version of the Microsoft
              ODBC Driver for Oracle worked fine with Oracle Client 8.0.x/8i. In fact, in
              independent testing by Oracle Support the Microsoft ODBC Driver performed
              better than Oracle's ODBC Driver and both the Oracle and Microsoft OLE DB
              Providers available when 8i shipped.

              --
              Michael D. Long


                Comment

                • TomTom
                  #5
                  Re: Oracle ODBC connection problem

                  This has to be one of the most pathetic problem I've ever run into.

                  My PATH was:
                  PATH=C:\blah;.. .; C:\oracle\ora81 \bin;...;C:\bla hblah;
                  instead of:
                  PATH=C:\blah;.. .;C:\oracle\ora 81\bin;...;C:\b lahblah;

                  Noticed the difference? Neither did I in the beginning.
                  There was a single *space* before the ORACLE_HOME directory in the
                  PATH, and it seems xp does not handle this!! I had checked my PATH but
                  could never ever imagine the problem came from this misplaced space. I
                  am speechless, it costed me several days of work.

                  Thanks for pointing me into the right direction!!

                  SerGioGio

                  info@Boecker-OCP.com (Yukonkid) wrote in message news:<ed737cdd. 0409210507.6017 d299@posting.go ogle.com>...
                  "SerGioGio" <sergiogio@yaho o.frwrote in message news:<414fca4e$ 1@news.starhub. net.sg>...
                  Hello,

                  I am going nuts. I am trying to connect to my local ORACLE instance using
                  ODBC.
                  It used to work few weeks ago, but it fails now.

                  Connection with:
                  - SQL*plus: connection works!
                  - DataDirect 5.0 Oracle Wire protocol (3rd party ODBC driver): connection
                  works when I hit the driver's "test connection"
                  but not anymore in real case scenario (using th DSN from an application).
                  - Oracle ODBC driver 9.02.00.05: connection does not work when I hit the
                  driver's "test connection", I get:
                  Unable to connect
                  SQLState=IM004
                  [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV
                  failed
                  - Microsoft ODBC for Oracle 2.575.1022.00: cannot even configure the ODBC
                  data source, always get:
                  The Oracle(tm) client and networking components were not found.
                  These components are sypplied by Oracle Corporation and are part
                  of the Oracle Version 7.3 (or greater) client software installation.
                  You will be unable to use this driver until these components have been
                  installed.

                  I am running Oracle version 9.2.0.1.0 on an xp Home Computer SP1 FAT32, and
                  trying to use ODBC on the same computer. I installed the Oracle client
                  version 9.2.0.5 to solve the problem but it did not work. I searched the
                  newsgroup for the error messages but could not find any solution solving my
                  problem - I do not think it is a permission problem on a registry or on a
                  file system directory. I also installed the latest MDAC with no success.

                  This used to work but does not anymore!! I do not know how/when/why it got
                  corrupted. Does anyone have any clue on what could be going on here?

                  Thanks in advance for your help,

                  Regards,

                  SerGioGio
                  >
                  Hi,
                  >
                  2 recommendations :
                  >
                  * check PATH setting on your Windows if the ORACLE_HOME containing the
                  ODBC DLLs is listed first
                  * Set your ORACLE_HOME explicit with "Oracle home selector" (should be
                  available under the menu 'Oracle installation products'
                  >
                  yk

                    Comment

                    • Raju
                      #6
                      Re: Oracle ODBC connection problem

                      Hi All,

                      Yes this is a know problem with xp and oracle 9i. If i'm correct i
                      found it on metalink(fix).

                      good luck.

                      Raju

                        Comment

                        Previous template Next
                        Working...