Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't use Sql*Xl, as can't configure the ODBC driver.

639995Jul 14 2008 — edited Jul 16 2008
HI,

I have installed Oracle db 10.2.0 and developersuite 10g on my laptop.

My tnsnames.ora file looks like this...

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

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(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)
)
)


I am trying to configure the ODBC driver so that i can use the SQL*XL that exchanges data from Microsoft Excel to the database.
I am sorry, if i don't know the right terminology here as i am very new to Oracle and I am not a DBA. I trained on Developper 10g
and a friend configured the database on my laptop.

I understand that one needs to configure the ODBC driver to be able to use SQL*XL.

Now the problem i am facing is that everytime i try to configure the driver, as per the rules stated in the help file of the ODBC folder
in oracle, i get the following error.


UNABLE TO CONNECT TO SQLSTATE = IM003. SPECIFIED DRIVER COULD NOT BE LOADED DUE TO SYSTEM ERROR 998. (ORACLE IN OraDb10g_home2)

and when i try to connect to the database directly from MS Excel, using the same parameters i used to configure the ODBC driver, it gives me
a similar message saying 'the specified driver could not be loaded due to system error 127.

please help!!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2008
Added on Jul 14 2008
6 comments
431 views