I am having some trouble getting Zope to work with a MS SQL Server database. I can set the ODBC connection on the server and then add ZODBC connection to a folder matching that connection. I can browse the new connection and see the tables, but when I try to test any simple SQL I get the following error: ValueError unpacked sequence of wrong size Any clues? Thanks. -- Guy Davis mailto:davis@arc.ab.ca (403) 210-5334 Alberta Research Council
+----[ Guy Davis ]--------------------------------------------- | I am having some trouble getting Zope to work with a MS SQL Server database. I can set the ODBC connection on the server and then add ZODBC connection to a folder matching that connection. I can browse the new connection and see the tables, but when I try to test any simple SQL I get the following error: | | ValueError | unpacked sequence of wrong size | | Any clues? Thanks. I get this in the test interface too, but, if I make a ZSQL Method and test it it works fine. I'd say that the test interface is a bit buggered. -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068 |akm@theinternet.com.au|
In article <200003172348.JAA52167@mail.theinternet.com.au>, Andrew Kenneth Milton <akm@mail.theinternet.com.au> writes
+----[ Guy Davis ]--------------------------------------------- | I am having some trouble getting Zope to work with a MS SQL Server database. I can set the ODBC connection on the server and then add ZODBC connection to a folder matching that connection. I can browse the new connection and see the tables, but when I try to test any simple SQL I get the following error: | | ValueError | unpacked sequence of wrong size | | Any clues? Thanks.
I get this in the test interface too, but, if I make a ZSQL Method and test it it works fine. I'd say that the test interface is a bit buggered.
Someone posted a fix. Dunno if it made it into 2.1.5 though... ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.com/dynamo - The Homebuilt Dynamo http://www.compkarori.com/dbase - The dBase bulletin
participants (3)
-
Andrew Kenneth Milton -
Graham Chiu -
Guy Davis