>>>>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

Thank for your help !.