>>>Hello all,
>>>Can anyone explain to me why when i select a field in SQL server with type varchar(1000), it return a memo field with length 255 if i try in Windows 98; but if i try with Windows NT, it return a memo field with length 1000 ? How can I resolve problem in Windows 98.
>>>
>>>(I use SQLEXEC to exec SQL select commands)
>>>TIA
>>
>>It probably has to do with the ODBC driver. Check to see if they are the same version. I always tend to use the latest version.
>>DLC
>
>Hi David,
>Thanks for your help!. I tried to use with SQL Server ODBC Driver version 3.70.06.23 and it's OK. However, i can't force update this version on client machine use my setup program even i checked ODBC Driver in setup wizard.
>How can i do it ?
>
>TIA

I think you just need to update the DLL. Otherwise, they will need to go through the setup of SQL Server 7. I keep a copy of the 120 day version of SS7 that has helped in a situation like this.
DLC