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!
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.

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.


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


Current Time: Sun Dec 04 04:42:28 CST 2016

Total time taken to generate the page: 0.08987 seconds