[Zope] ODBC connection to Oracle

[Theodore Patrick]

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 )