Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Microsoft Access - Oracle8i
How do I create a tnsnames.ora entry for an Access database? What does it look like?
On Tue, 21 Nov 2000 01:05:46 GMT,
SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK (Brian Tkatch)
wrote:
>On Tue, 21 Nov 2000 00:31:59 GMT, timf97_at_earthlink.net wrote:
>
>>I have a Microsoft Access database with tables in it that I need to be
>>able to dynamically access from an Oracle 8i (8.1.6) database.
>>
>>I have figured out how to create a linked table (in the Access
>>database) to a table which actually exists in the Oracle database.
>>
>>What I really need is either a linked table (in the Oracle database)
>>to the table which actually exists in the Access database
>>(I've tried using the create database link ... (but I must have
>>something wrong with it, because I can't get it working).
>>
>>- or -
>>
>>Some way to dynamically update the Oracle linked table that I have
>>anytime one of the Access tables is changed.
>>
>>Anybody have any ideas, or advice?
>
>Database links must point to a valid TNSname in tnsnames.ora (if you
>are using tnsnames). Make sure that is set up properly before
>attempting to create the link.
>
>Brian
>
Received on Mon Nov 20 2000 - 22:10:06 CST