OraFAQ Forum: Programming Interfaces » unable to retrieve data from SQL server

Home » Open Source » Programming Interfaces » unable to retrieve data from SQL server (Oracle 9i, MS SQL Server 2005)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unable to retrieve data from SQL server [message #378953]

Sat, 03 January 2009 01:50

alloli_arvind
Messages: 2
Registered: January 2009
Location: Bangalore

Junior Member

When I am trying to access SQL table data from Oracle 9i, I am getting following error message.

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user 'SA'. (SQL State: 28000; SQL Code: 18456)
ORA-02063: preceding 2 lines from MYDBLINK

please let me know the solution

Report message to a moderator

Re: unable to retrieve data from SQL server [message #378958 is a reply to message #378953]

Sat, 03 January 2009 02:30

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

There is a mismatch between:
- unable to retrieve data from SQL server
- connection from ORACLE to a non-Oracle system

See:
http://forums.oracle.com/forums/thread.jspa?messageID=1746380
http://www.google.com/search?hl=en&q=SQL+Code+18456&btnG=Google+Search&aq=f&oq=

Regards
Michel

Report message to a moderator

Re: unable to retrieve data from SQL server [message #379113 is a reply to message #378953]

Mon, 05 January 2009 00:01

alloli_arvind
Messages: 2
Registered: January 2009
Location: Bangalore

Junior Member

Thanks Michel. It worked !!!!!!!!!!!

Regards
Arvind

Report message to a moderator

Previous Topic:	Question regarding OLE2....
Next Topic:	NLS_LANG and Perl

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 28 13:12:35 CDT 2023