Hi all,
I have setup an oracle10g database. I can connect to the data base
through sqlplus from the local machine. I want to export msaccess
tables to the oracle db, but it seems that I'm unable to provide the
ODBC driver (the one that comes with windowsxp) with a vialed
connection string. I searched the web but I hadn't found a working
example. here is my tnsnames file, does anybody have an idea what the
connection string is? I've been trying the following connection string:
"Driver={Microsoft ODBC for Oracle};Server=test;Uid=scott;Pwd=;"
with quotes and every thing.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = test.myhome.com)(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)
)
)
Received on Sun Nov 19 2006 - 06:36:55 CST
