We have had mixed results depending on the ODBC driver you use to make your DSN. Here is what I found. 1. Microsofts ODBC Driver for ORACLE on NT4.0, NT2000 -CREATE DSN -OK -ZOPE ZODBC -OK -ZSQL METHODS -OK 2. ORACLE ODBC DRIVER on NT 4.0, Especially NT2000 -CREATE DSN -OK -ZOPE ZODBC CONNECTION -OK Visually! On First Query it will break. -ZSQL METHODS -Broken When in doubt use the MICROSOFT DRIVER for ODBC! That is our rule. You will also find that this same problem exists in using ORACLE drivers when viewing databases via ACCESS. It will typically crash Access and potentially more. Theodore E. Patrick Ishophere.com - Indigo Networks -----Original Message----- From: vsbabu@mamlegault.mamlegault.com [mailto:vsbabu@mamlegault.mamlegault.com] Sent: Thursday, June 01, 2000 12:16 PM To: zope@zope.org Subject: [Zope] ODBC connection to Oracle Hi there, Has anyone tried connecting using ZODBC from a WinNT machine to an Oracle database? The ODBC connection works. But when I create a ZODBC connection from ODBC dsn, it doesn't. I give the connect string as DSN userid password as mentioned under ZODBC add screen... Any help? Thanks Babu http://vsbabu.csoft.net _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )