Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Linking MS Access DB into Oracle
Hello Tom
thanx for your help.
Now I changed my tnsnames and listener and restart the listener.
But I don't know how to Fill out the listener.ora correctly.
Does somebody knows what I have to do Step by Step to Connect to ODBC ??
Micha
tnsnames.ora
(ADDRESS=(PROTOCOL=tcp) (HOST=Barny) (PORT=1521)) (CONNECT_DATA = (SID=ODBCTest)) (HS = OK))
listener.ora
(SID_DESC =
(SID_NAME=ODBCTest)
(ORACLE_HOME=C:/WINNT/system32/)
(PROGRAM=DBase Test)
)
I tried
PROGRAM=DBase Test (Name of the ODBC Service) ??? PROGRAM=ODBCAD32.EXE (ODBC Admin Programm) ??? PROGRAM=ODBCJT32.DLL (Driver) ???
Then:
CREATE DATABASE LINK test123 USING 'MyODBC';
select * from nase_at_test123;
Tom Best <tabest_at_bellatlantic.dontspamme.net> schrieb in im Newsbeitrag: JZZg5.2159$oA6.138109_at_typhoon2.ba-dsg.net...
> Micha: > > If you are talking about make Oracle be able to get to Access tables, then > you can use Oracle Heterogeneous Services. You set this up with database > links, and an ODBC driver. > > See this doc: > > http://technet.oracle.com/doc/server.815/a67784/hs_ch7.htm > > HTH, > Tom Best >Received on Mon Jul 31 2000 - 00:00:00 CDT