Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Pittsburgh, PA

    Arrow Unanswered: TSQL/ODBC read of Informix 9.3 Blob field

    I am trying to read an Informix 9.3 blob field into a TSQL (SQL Server Stored Procedure) and the data type conversion is not supported thru the MS ODBC Driver installed with Win2000/SQL2000. Does anyone know of another method to retrieve this data, or of a vendor that provides an ODBC driver that supports the Informix blob data type. Thanks!

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    Try to extract the source into a file, but pay most attention to field and row delimiters. Fortunately, SQL supports muti-character delimiters for both. The only unknown is would Informix do the same

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts