Home » RDBMS Server » Server Administration » connection from oracle to Microsoft Access (Oracle 9.0.2.0.0 Windows Server 2003)
connection from oracle to Microsoft Access [message #287776] Thu, 13 December 2007 07:24 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear All,

I am trying to establish a link from oracle to access DB by using the following link

http://www.orafaq.com/node/60

i had followed all the steps but when i try to select something
it gives the following error

Link : "ACCESS1.US.ORACLE.COM"
Error : ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]
ORA-02063: preceding 2 lines from ACCESS1

Please suggest!

Report message to a moderator

Re: connection from oracle to Microsoft Access [message #287778 is a reply to message #287776] Thu, 13 December 2007 07:29 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
what is value for global_names parameter ?
TRUE OR FALSE if true then set to false and try.

Report message to a moderator

Re: connection from oracle to Microsoft Access [message #287779 is a reply to message #287776] Thu, 13 December 2007 07:38 Go to previous message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
its working now

it was solely my mistake.
sorry for ur inconvenience.

Report message to a moderator

Previous Topic: Cannt drop tablespace (please, urgent)
Next Topic: Unable to resize data tablespace
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 05:02:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.