Reading data from Sql Server table NVARCHAR field

Posts: 301

Joined: Fri Jun 01, 2007 09:07 AM

Reading data from Sql Server table NVARCHAR field
Posted: Thu Jan 31, 2013 03:41 PM

Hi,
I have a problem with reading data from INFORMIX SQL table for NVARCHAR fields,
If i use ODBC receive error "Unknown Type or is not supported curently"
If use ADO there is not reported error byt all readed data from NVARCHAR fields are empty

Code (fw): Select all Collapse

oCn   := TOleAuto():New( 'ADODB.Connection' )
try
   oRs := TOleAuto():New( 'ADODB.RecordSet' )
   WITH OBJECT oRs
      :ActiveConnection := oCn
      :Source           := 'SELECT * from tbl_statuses_new'
      :CursorLocation   := 3  // adUseClient
      :Open()
   END
catch oErr
   msginfo("Error !")
end try

If look data from Delphy Sql Explorer i see something like binary code or encrypted data ...
I can see normaly data only from DBACCESS

(I can insert or delete data without problem.)

Some sugestions ?

Best regards,

FiveTech Support Forums

Continue the discussion