Home » SQL & PL/SQL » Client Tools » Oracle connection to SQL server (ORA-28500: connection from ORACLE to a non-Oracle system)
Oracle connection to SQL server [message #496710] Wed, 02 March 2011 01:27 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
I am using dg4msql to connect to SQL server from Oracle(10.2.0.4, with AIX 5.3).

#from my laptop sqlplus (10.2.0.2)
SQL>select count(*) from table1@mssql;   #works
SQL>select * from table1@mssql;          #ERROR

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver]String data, right truncation
{01004}[Oracle][ODBC SQL Server Driver]String data, right truncation {01004}


#from my laptop, TOAD
Both queries works fine.


i have compared
"select * from nls_session_parameters;" values , TOAD and sqlpus gives same result.

Any idea ,what else i should check ?
Thanks
Re: Oracle connection to SQL server [message #496712 is a reply to message #496710] Wed, 02 March 2011 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 65988
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what else i should check ?

The table definition.
Post "desc table1@mssql"

Regards
Michel
Re: Oracle connection to SQL server [message #496715 is a reply to message #496710] Wed, 02 March 2011 01:53 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
i have tried individual select on each column on this tables, from sqlplus. and these are the two problem columns in this sql server table.


[RequestName] [varchar](50)
[Justification] [varchar](2000)

But works fine from TOAD.

Re: Oracle connection to SQL server [message #496732 is a reply to message #496715] Wed, 02 March 2011 02:53 Go to previous message
Michel Cadot
Messages: 65988
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What are the NLS_LANG values used in both cases?

Regards
Michel
Previous Topic: SQLPLUS WIndow in oracle 11g
Next Topic: how to get sql query output into text file without spool statement
Goto Forum:
  


Current Time: Wed Nov 21 10:49:59 CST 2018