[Zope] ZODBCDA problems?

[Scott Lewis]

hi folks,

i posted earlier with a problem with ZODBCDA v3.03 and MS SQL Server 7. 
i have a field that is a VARCHAR length 500. using Zope 1.10.2, this field is 
truncated to 256 characters on input and output. when i use the same 
SELECT and INSERT statements with the database clients, everything 
works as expected.

some info in the database help files indicates that the problem might lie 
with ZODBCDA. versions of the database before 7.0 didn't support 
VARCHARs greater than 256. it looks like there might still be a limitation, 
depending on how the database is accessed.

this is from the SQL Server Books Online:

The osql utility uses the ODBC database application programming interface 
(API). It is a replacement for the isql command prompt utility that is based 
on the DB-Library API. Both utilities are provided with Microsoft SQL 
Server™ version 7.0. The DB-Library API remains at a SQL Server 6.5 level; 
therefore, applications that depend on DB-Library, such as isql, do not 
support some SQL Server version 7.0 features. For example, isql cannot 
access columns defined with the ntext data type and truncates any char, 
varchar, nchar, or nvarchar columns that are longer than 255 bytes. Except 
for these limitations in isql, both osql and isql support the same 
functionality.  

is something similar in ZODBCDA causing the truncation? if so, should i 
find another way to do things or is a fix possible?

thanks in advance for any help,

-scott

-----
Scott Lewis
Baltic Avenue Productions
csl@balticave.com