| Oracle connection to SQL server [message #496710] |
Wed, 02 March 2011 01:27  |
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 #496715 is a reply to message #496710] |
Wed, 02 March 2011 01:53  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
