Recover Data From SQLServer 2000

[fausto.lupercio]

I used TD 5.1 SP2, I migrate apps from CTD2000 (in this version all ak), in access dialog box when are connection to database SQLServer 2000 ODBC way, the rocover data is bad.. in database store a data ( DtlwXgu|,=) as image and the recover other data: please to see the image. The ODBC Driver version is: 2000.85.1117.00.

[Ana Paula Bonani]

Hi Fausto,

What version of SQLTalk are you using?
I tested with SQLTalk 10.0.1 PTF1 build which is installed with TD and couldn't reproduce the problem.
The data:

TEST50
======
DtlwXgu|,=

returned okay from SQLTalk.

I inserted it from SQL Server 2000 using an image datatype as you indicated.

My ODBC version is 2000.85.1064.00. You seem to be using a newer one. Please let me know the SQLTalk version and we'll go from there.

Thanks,

[fausto.lupercio]

I Used SQLTalk installed with TD 5.1.

The problem is: Query analizer show as , char to é char... In database storage in reality string: DtlwXgu|é= , but SQLTalk not show it.

Thanks.