[freetds] SQL Server image data type

Frediano Ziglio freddyz77 at tin.it
Tue Aug 22 14:31:53 EDT 2006


Il giorno lun, 21/08/2006 alle 08.57 -0400, Stacy Gaddy ha scritto:
> I am using FreeTDS and unixODBC to reach a SQLServer 2000 database through 
> Oracle 10g's Generic Connectivity feature.  My intention is to bulk load 
> several tables from SQLServer to Oracle through this setup.  The tables on 
> the SQLServer side have fields of type "image".  If I understand correctly, 
> the SQLServer "image" data type get mapped to the Oracle "LONG RAW" data 
> type.  When I attemp to query the SQLServer table through Oracle's Generic 
> Connectivity, I get:
> Error:ORA-02068: following severe error from MSSQL
> ORA-28511: lost RPC connection to heterogeneous remote agent using 
> SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=yosemite)
> (PORT=1521)))(CONNECT_DATA=(SID=mssql)))
> 

I don't know Oracle so I don't know corresponding Oracle data but it
seems that for some reasons the remote agent exit... FreeTDS support
image without problem (expect the memory limit...). You should try to
enable unixODBC trace and post last rows.

> My question is this....does FreeTDS/unixODBC combination support the image 
> datatype?  If so, are there any special configuration items that need to be 
> considered?
> 
> I have this same setup working successfully using the ODBC drivers and Driver 
> Manager from DataDirect.  I would prefer to use an opensource solution.
> 
> Any input would be appreciated.

bye
  Frediano





More information about the FreeTDS mailing list