Home » Open Source » Programming Interfaces » unable to retrieve data from SQL server (Oracle 9i, MS SQL Server 2005)
unable to retrieve data from SQL server [message #378953] Sat, 03 January 2009 01:50 Go to next message
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
Re: unable to retrieve data from SQL server [message #378958 is a reply to message #378953] Sat, 03 January 2009 02:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
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
Re: unable to retrieve data from SQL server [message #379113 is a reply to message #378953] Mon, 05 January 2009 00:01 Go to previous message
alloli_arvind
Messages: 2
Registered: January 2009
Location: Bangalore
Junior Member
Thanks Michel. It worked !!!!!!!!!!!

Regards
Arvind
Previous Topic: Question regarding OLE2....
Next Topic: NLS_LANG and Perl
Goto Forum:
  


Current Time: Mon Dec 05 09:11:52 CST 2016

Total time taken to generate the page: 0.07869 seconds