[Zope] ODBC - 1 step forward - woops I tripped

Thomas B. Passin tpassin@mitretek.org
Tue, 16 Nov 1999 16:24:06 -0500


From: rgines@purina.com <rgines@purina.com>

Could there be a file permissions issue?  I'm not up on NT file permissions, but
maybe the text file just has the wrong permissons.  Anyway, I'd just go directly
to one of your DB2 databases. I often have trouble getting those Jet drivers
working right on the fly, but I never had a problem with SQLAnywhere.

Cold Fusion requires the ODBC datasource to be set up as a "system" datasource.
The ODBC default, however,  is a "user" datasource.  Maybe on NT Zope needs to
see a system rather than a user odbc datasource.  You can test that out easily.

Tom Passin

<dtml-snip>
>to go directly to the connection.  When I pointed to the ZSQL Method the
>'__len__' error
>disappeared but I am back to the error
>
>Error Type: sql.error
>           Error Value: ('S1000', -1032, "[Microsoft][ODBC Text Driver] The
>Microsoft Jet
>           database engine cannot open the file 'ZopeTest.txt'. It is
>already opened exclusively
>           by another user, or you need permission to view its data.")
>
>...   I may just jump in feet first and try to connect to the DB2
>databases anyway.
>
>Thanks for setting me straight on where to point my Method.
>
</dtml-snip>