10 Replies Latest reply on Nov 4, 2009 4:25 AM by 731963

    Oracle ODBC driver configuration

    533689
      Alright so I just installed oracle 10g enterprise edition on my home pc (windblows xp pro - no service packs eh :* )

      I can connect to the database's sqlplus with system / password / orcl

      my tnsnames.ora looks like

      # tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
      # Generated by Oracle configuration tools.

      ORCL =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = DNTFCUKWITHMYIP)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      )
      )

      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
      )
      )

      so Now i want to add a system dsn so that I can use toady to work with my database right?

      but when i go to add the Oracle in OraDb10g_home1 and throw in the TNS service name as ORCL it bombs out and says

      Unable to connect
      SQLState=IM003
      Specified driver could not be loaded due to system error 998 (Oracle in OraDb10g_home1)

      what does one need to do here?

      helppppppppp!!!!!