[Zope] ODBC connection to Oracle

2000-06-01 Thread vsbabu

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  -  [EMAIL PROTECTED]
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 )




RE: [Zope] ODBC connection to Oracle

2000-06-01 Thread 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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 01, 2000 12:16 PM
To: [EMAIL PROTECTED]
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  -  [EMAIL PROTECTED]
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 )

___
Zope maillist  -  [EMAIL PROTECTED]
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 )