Oracle Database Discussions

Hi,

I was able to set up a db link from Oracle 11.2.0.1 to SQL Server 2005 using DG4ODBC.

When trying to select a column with nvarchar(max) datatype from the db link I get the following error:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Microsoft][SQL Native Client]String data, right truncation {01004}[Microsoft][SQL Native Client]String data, right truncation {01004}[Microsoft][SQL Native Client]String data, right truncation {01004}[Microsoft][SQL Native Client]String data, right truncation {01004}[Microsoft][SQL Native Client]String data, right truncation {01004}
ORA-02063: preceding 2 lines from SQLSERVER_DBLINK

The actual data in the column doesn't exceed 31 chars but the query still fails.

Any suggestions?
Thanks.