The DDL and query were really nothing special. The database I connected to is an Oracle 8.0.5 installation. I created the table with SQL*Plus: create table zopetest( id number(9), name varchar2(255)); followed by a few inserts (and checked with a select). Then I typed the following on the Test tab page: select * from zopetest and clicked on the Submit Query button. The Browse Option in Zope works fine. Any other queries I tried, with different attributes, tables and even other ZODBC database connections failed exactly the same way.
On 1/20/00 12:29 PM, Roland Reumerman at zope_ddi@hotmail.com wrote:
Some time ago I asked a question about some error I received when trying to do a SQL SELECT query. I didn't receive any reaction on that, and I couldn't find any mention of it on the Zope.org site, so I'll just ask it again..
I was running it on Windows NT 4 SP5, using the ZODBC product on Zope 2.1.2. It returned the following error message: ErrorType: ValueError Error Value: unpack sequence of wrong size
Can you share your query and DDL with us? That would be helpful in knowing what might be the problem.
Chris
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
In article <20000120170008.3826.qmail@hotmail.com>, Roland Reumerman <zope_ddi@hotmail.com> writes
followed by a few inserts (and checked with a select). Then I typed the following on the Test tab page:
select * from zopetest
Happens to me too! But only on the test tab page. Otherwise ODBC seems to mainly work. I have this other curious and extremely annoying problem. If I log into /manage, then almost invariably Zope disconnects the ODBC connection. Sometimes it recovers the connection, other times I have to shut Zope down and restart it before it will reconnect the ODBC connection. The problem seems to be related to the ODBC driver. I am using NT4 sp5 and Interbase ( which Inprise recently announced was being open sourced ). When I use the Visigenic driver that came with version 4, I have the above problem. If I use the Intersolv driver that comes with version 5, then the problem occurs much less frequently, but the Intersolv driver seems unable to get all the data from a VAR char field so is pretty useless. ------- 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 (2)
-
Graham Chiu -
Roland Reumerman