Tom,

Thanks for the reply. I will check the ODBC driver I'm using.

Regarding OLE DB drivers, I'm not familiar with them other than knowing that they are the data access component used by ADO. Do you have suggestions as to where/how I can familiarize myself with them?

Thanks,

David
>>Hi all,
>>
>>I have a problem which seems to be widely encountered in using SQL Passthrough with SQL Server: Truncated conversion of VARCHAR fields. Specifically, the VARCHAR fields come over as 255 character memo fields.
>>
>>I've been using SQL Passthrough a fair bit, but I am relatively new to ADO. I created an ADO recordset of the same data, and it appears that it too truncates the VARCHAR fields at 255 chars. I was hoping that ADO would be a way around this limitation.
>>
>>Am I missing something? Is there some way to bring over the entire VARCHAR field using SQL Passthrough or ADO? If not, how do people work around this? My system is storing long descriptions in memo fields, and I need to update these descriptions on the web, which uses SQL Server as the backend.
>>
>>Any thoughts would be appreciated.
>>
>>David Marlin
>
>David;
>
>You may be using an ODBC driver previous to SQL Server 7.0, which would cause truncation to 255 bytes. Be sure to check this. Have you tried OLE DB drivers?
>
>Tom