General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ADO vs. SQL Passthrough
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only