|
|
| Re: link MS Access tables to Oracle [message #55022 is a reply to message #55017] |
Fri, 27 December 2002 02:34   |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
hello,
What do u want to do ? if incase u want to transfer tables from access to oracle, then all u need to do is 1. Keep the Access table names in UPPERCASE
2. Choose Export from Access and give the ODBC driver details which u need to configure for oracle database.
In case if u want to Query data on MS-ACCESS and ORACLE ..then the best way is to use a front-end like VB, create two connection strings one for Access and one for Oracle and do the workaround..
sai
|
|
|
|
| Re: link MS Access tables to Oracle [message #55032 is a reply to message #55022] |
Fri, 27 December 2002 11:01 |
Kenneth
Messages: 5
Registered: August 2002
|
Junior Member |
|
|
|
Basically, I want to look up my MS Access tables from Oracle at run-time. I have read some posts/articles about generic connectivity, which let me to do some kinds of these through ODBC. However, I have never made it work.
|
|
|
|
| Re: link MS Access tables to Oracle [message #55035 is a reply to message #55022] |
Fri, 27 December 2002 12:46 |
Kenneth
Messages: 5
Registered: August 2002
|
Junior Member |
|
|
Maybe I should give more informations on how I setup the connection.
Under $Oracle_home/hs/admin, I have initLinkDatabase.ora. And the file contains:
HS_FDS_CONNECT_INFO = LinkDatabase
HS_FDS_TRACE_LEVEL = ON
HS_FDS_TRACE_FILE_NAME=HS.Log
In listener.ora, which is under $Oracle_home/network/admin, I have
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Dasher)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleora92)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = LinkDatabase)
(ORACLE_HOME = C:oracleora92)
(PROGRAM = hsodbc)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = C:oracleora92)
(SID_NAME = test)
)
(SID_DESC =
(GLOBAL_DBNAME = OEMREP)
(ORACLE_HOME = C:oracleora92)
(SID_NAME = OEMREP)
)
)
And in tnsnames.ora, I have
LinkDatabase =
(Description =
(address = (protocol=tcp)(host=Dasher)(port=1521))
(connect_data=(sid=LinkDatabase))(HS=ok)
)
Please help~
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
