Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: [CP] Getting Oracle 7 & MS Access 2k to talk to each other
I am assuming you have an ODBC driver for Oracle installed. If not go to
Oracle's technet site and down load it. Next you need to install the Oracle
client software. You should have it. Then you need to find out the user
name and password of the Oracle account. Also you need to know the service
name to connect to.(ask your DBA for this information)
Once you have that create an ODBC data source using the Oracle driver.
Then in Access choose File Link table choose an ODBC data source. Then in
the odbc dialog choose the source you set up.
Jim
"rtdos at yahoo dot com" <rtdos_at_hotmail.com> wrote in message
news:bZCE7.119$FU5.296380_at_news.uswest.net...
> How do I use ODBC to get Oracle & access to talk to each other ? Where do
I
> need to start looking ?
>
> --
> J.Wood
> rtdos_at_juno.com
>
>
Received on Fri Nov 02 2001 - 15:35:22 CST