<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2523" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=321022920-07122004>Hi
all,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=321022920-07122004> 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</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=321022920-07122004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=321022920-07122004><!--StartFragment --><FONT face="Times New Roman"
size=3> <STRONG>Error Type: sql.error</STRONG><BR><STRONG>Error Value:
('22001', 8152, '[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary
data would be
truncated.')</STRONG> <STRONG>. </STRONG></FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=321022920-07122004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=321022920-07122004><FONT
face="Times New Roman" size=3>the insert statement is as follows
</FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=321022920-07122004><FONT
face="Times New Roman" size=3></FONT></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=321022920-07122004><FONT
face="Times New Roman" size=3>Insert into status (status)
value(<dtml-sqlvar status=string>)</FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=321022920-07122004><FONT face=Arial
size=2></FONT></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=321022920-07122004><FONT
face="Times New Roman" size=3> 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. </FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=321022920-07122004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=321022920-07122004>I am using Zope
2.6.4 and ZODBCDA 3.1.2b2 for python v 2.1</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=321022920-07122004><FONT
face="Times New Roman" size=3></FONT></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=321022920-07122004><FONT
face="Times New Roman" size=3>Any help would be
appreciated.</FONT> </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2>Edward R. Kellogg</FONT></DIV>
<DIV><FONT face=Arial size=2>Distributed Systems Specialist I</FONT></DIV>
<DIV><FONT face=Arial size=2>Wayne County HSA/ </FONT><FONT face=Arial
size=2>Wayne County Courthouse</FONT></DIV>
<DIV> </DIV></BODY></HTML>