Home » RDBMS Server » Server Administration » Re: remote connecting oracle and MS Access
Re: remote connecting oracle and MS Access [message #54531] Wed, 20 November 2002 14:19 Go to next message
rena
Messages: 8
Registered: November 2002
Junior Member
Again i have some questions:

the host specified in the tnsnames.ora file is the host where MS Access is installed or the host where oracle is installed?

If it is the host where MS Access is installed which is the port?

my entry in tnsanames.ora file is:

MYDB.CSD.UCH.GR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost.di.uoa.gr
)(PORT=1521))
(CONNECT_DATA = (SID = mydb)(SERVER = DEDICATED))
(HS=OK)
)

where mydb.mdb is my Access database and the system dsn in the machine where MS Access is installed is mydb.

when i create a db with the command:

create database link mylink using 'MYDB.CSD.UCH.GR';

and trying to select :

select * from PRODUCT@mylink;

i am getting the follwing error:

ORA-12154:TNS:Could not resolve service name

Does anyone about this?

If yes please answer me because i need it as soon as possible

Thanks in advance
rena

Report message to a moderator

Re: remote connecting oracle and MS Access [message #54533 is a reply to message #54531] Wed, 20 November 2002 15:46 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
u are trying to connnect MS-ACCESS AND ORACLE through
tnsnames.ora entries???
OR
am i missing something BIG?
i dont think, you cann connect ms-acces and oracle through sqlnet.
you need to make use of ODBC or any other options(like
linked server with sqlserver).

Report message to a moderator

Previous Topic: Urgent! Oracle Installation Failure - Re-linking errors.
Next Topic: Urgent Problem in performance of a query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 18:09:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.