Devart Forums

i need help to transfer data from BLOB (TEXT) into MS-SQL

the source will be table Customer1, Name(varchar), Code(varchar), Remarks(BLOB SUB_TYPE TEXT SEGMENT SIZE 80)

to

the destination table Customer2, Name(Varchar), code(varchar), remarks(varchar)


i try to use the code below

Dim cn As New ADODB.Connection
Dim cn2 As New ADODB.Connection
Dim rs As New ADODB.Recordset

rs.Open "Select CODE,NAME,REMARKS from Customer1", cn, adOpenForwardOnly, adLockReadOnly

cn2.Execute "Insert into Customer2 (Code,Name,Remarks) Values ('" & rs("Code") & "','" & Replace(rs("Name") & "", "'", "''") & "','" & rs("REMARKS") & "')"


transfering field Code and Name are successful, but Remarks is not succesful where i get the unrecognized character inside my destination field.
any suggestion? is it database limitation?


i am using InterBase 6 Open Edition, IBConsole Version 1 as source and Microsoft SQL Server 2005 as destination.


very urgent n thanks in advance

Please note that this forum is dedicated to IBDAC components, not to the InterBase\Firebird servers or any other data providers. As far as I can see you are using Visual Basic that isn't supported by IBDAC. Please send your questions to your data access components vendor.