[Zope] Problem with ZODCBD and Zope 2.51 (urgent!)

Robert Rottermann robert@redcor.ch
Fri, 3 May 2002 21:53:34 +0200


Hi there,
I installed ZODBCDB (newest version for 2.4 with Python 2.1)
Under Python 2.4 everything works fine.

Under 2.51 when I try execute a SQL-Statement like
select * from Employees where Name = 'David'

I get the following error:

----------------------------------------------------------------------------
----

 Error, sql.error: ('07001', -3010, '[Microsoft][ODBC Microsoft Access
Driver] 1 Parameter wurden erwartet, aber es wurden zu wenig Parameter
\xfcbergeben.')
--> Translation. 1 Parameter was expected, none where given

----------------------------------------------------------------------------
----

SQL used:

select * from Employees where Name = 'David'


----------------------------------------------------------------------------
----


What is the problem?

I am giving a speech on Zope next week and would like to show a DB
connection to MS-Access.
Therefore help is needed urgently.

Thank you very much
www.redcor.ch