Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQL Server image data type

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQL Server image data type
  • Date: Tue, 22 Aug 2006 20:31:53 +0200

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






Archive powered by MHonArc 2.6.24.

Top of Page