[Zope-DB] ZODBCDA problem.

[Ed Kellogg]

Hi all,
  I am having a problem the ZODBCDA connector. Have the query set up
correctly and it worked fine in the ZSQL Method however when it runs I
get
 
 Error Type: sql.error
Error Value: ('22001', 8152, '[Microsoft][ODBC SQL Server Driver][SQL
Server]String or binary data would be truncated.') . 
 
the insert statement is as follows 
 
Insert into status (status) value(<dtml-sqlvar status=string>)
 
 I am fairly new to Zope and is there a truncation issue with this
driver or maybe I am not preparing the statement correctly before
executing  it would help. I have scoured the net looking for an answer
on this issue. 
 
I am using Zope 2.6.4 and ZODBCDA 3.1.2b2 for python v 2.1
 
Any help would be appreciated.  
 
Edward R. Kellogg
Distributed Systems Specialist I
Wayne County HSA/ Wayne County Courthouse
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-db/attachments/20041207/145621a1/attachment.htm