[Zope] ODBC Connection

2000-12-12 Thread Emmon Simbo



Hi 

I have a few 
customers who are using Zope and have shown an interest inusing 
the 
OpenLink ODBC Drivers. Unfortunately, I am not familiar with Zope and wondered 
if there was a How-To that I can use to show me how to use Zope with ODBC. I 
have downloaded the ZmxODBCDA module but when I select this from the Products 
menu, it shows up as ZmxODBCDA(Brokenproduct ZmxODBCA). If I click on the 
link, I get

 File 
"D:\APPS\ZopeWeb\lib\python\OFS\Application.py", line 397, in 
import_products product=__import__(pname, global_dict, 
global_dict, silly) File 
"D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\__init__.py", line 91, in 
? import DA File 
"D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\DA.py", line 92, in 
? from db import DB, manage_ODBCDataSources File 
"D:\PROGRA~1\Zope22\lib\python\Products\ZmxODBCDA\db.py", line 87, in 
?ImportError: No module named mx.ODBC

Any ideas what's 
wrong here and secondly how I can go about making an ODBC 
connection.

Thanks for you help 
in advance

Best Regards,

Emmon SimboConsultantOpenLink 
SoftwareTel: +44 (0) 20 8681 7701Web: http://www.openlinksw.comXML  E-Business Infrastructure Technology Provider 


BEGIN:VCARD
VERSION:2.1
N:Simbo;Emmon
FN:Emmon Simbo
ORG:OpenLink Software
TITLE:Professional Services Consultant
TEL;WORK;VOICE:0208 681 7701
TEL;WORK;VOICE:0468 573 573
TEL;WORK;FAX:02086817702
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Amy Johnson House=0D=0A22-26 Dingwall Rd;Croydon;Surrey;CR0 9XF;United Kin=
gdom
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Amy Johnson House=0D=0A22-26 Dingwall Rd=0D=0ACroydon, Surrey CR0 9XF=0D=0AU=
nited Kingdom
ADR;HOME:;;United Kingdom
LABEL;HOME:United Kingdom
URL:http://www.openlink.co.uk
URL:http://www.openlinksw.co.uk
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20001106T182603Z
END:VCARD



RE: [Zope] ODBC Connection

2000-12-12 Thread Paolo Quaglia



Try to 
use the ZODBCDA 
http://www.zope.org/Products/DA/ZODBCDA


It 
works very well!

Paolo 
Quaglia


  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Emmon SimboSent: 
  Tuesday, December 12, 2000 11:26 AMTo: 
  [EMAIL PROTECTED]Subject: [Zope] ODBC Connection
  Hi 
  
  I have a few 
  customers who are using Zope and have shown an interest inusing 
  the 
  OpenLink ODBC Drivers. Unfortunately, I am not familiar with Zope and wondered 
  if there was a How-To that I can use to show me how to use Zope with ODBC. I 
  have downloaded the ZmxODBCDA module but when I select this from the Products 
  menu, it shows up as ZmxODBCDA(Brokenproduct ZmxODBCA). If I click on 
  the link, I get
  
   File 
  "D:\APPS\ZopeWeb\lib\python\OFS\Application.py", line 397, in 
  import_products product=__import__(pname, global_dict, 
  global_dict, silly) File 
  "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\__init__.py", line 91, in 
  ? import DA File 
  "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\DA.py", line 92, in 
  ? from db import DB, manage_ODBCDataSources 
  File "D:\PROGRA~1\Zope22\lib\python\Products\ZmxODBCDA\db.py", line 87, in 
  ?ImportError: No module named mx.ODBC
  
  Any ideas what's 
  wrong here and secondly how I can go about making an ODBC 
  connection.
  
  Thanks for you 
  help in advance
  
  Best Regards,
  
  Emmon SimboConsultantOpenLink 
  SoftwareTel: +44 (0) 20 8681 7701Web: http://www.openlinksw.comXML  E-Business Infrastructure Technology Provider 
  
  


Re: [Zope] ODBC Connection

2000-12-12 Thread Philipp Auersperg

the ZmxODBC DA uses the Zope-independent product mxODBC, that provides a generic 
Python DB API compliant ODBC interface to Python.

ZmxODBC installs mxODBC into lib/python/Shared/mx. The problem is that this path is 
not in the default PythonPath.

Solution:
move the mx directory from lib/python/Shared into a directory that's member of 
PythonPath (for example lib/python).

phil
*** REPLY SEPARATOR ***

On 12.12.2000 at 10:25 Emmon Simbo wrote:
Hi 

I have a few customers who are using Zope and have shown an interest in using the 
OpenLink ODBC Drivers. Unfortunately, I am not familiar with Zope and wondered if 
there was a How-To that I can use to show me how to use Zope with ODBC. I have 
downloaded the ZmxODBCDA module but when I select this from the Products menu, it 
shows up as ZmxODBCDA(Broken product ZmxODBCA). If I click on the link, I get
 

  File "D:\APPS\ZopeWeb\lib\python\OFS\Application.py", line 397, in import_products
product=__import__(pname, global_dict, global_dict, silly)
  File "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\__init__.py", line 91, in ?
import DA
  File "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\DA.py", line 92, in ?
from db import DB, manage_ODBCDataSources
  File "D:\PROGRA~1\Zope22\lib\python\Products\ZmxODBCDA\db.py", line 87, in ?
ImportError: No module named mx.ODBC


 
Any ideas what's wrong here and secondly how I can go about making an ODBC connection.
 
Thanks for you help in advance
 
Best Regards,

Emmon Simbo
Consultant
OpenLink Software
Tel: +44 (0) 20 8681 7701
Web: http://www.openlinksw.com
XML  E-Business Infrastructure Technology Provider 


___
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

2000-12-12 Thread Emmon Simbo

Thanks Philipp.

That solved the problem.

Is there actually a How-To on what to do as when I go to add a new
Datasource, I get the error

Error Type: NameError
Error Value: SQLDataSources

Thanks again for you answer

Emmon

-Original Message-
From: Philipp Auersperg [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2000 11:51
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [Zope] ODBC Connection


the ZmxODBC DA uses the Zope-independent product mxODBC, that provides a
generic
Python DB API compliant ODBC interface to Python.

ZmxODBC installs mxODBC into lib/python/Shared/mx. The problem is that this
path is not in the default PythonPath.

Solution:
move the mx directory from lib/python/Shared into a directory that's member
of PythonPath (for example lib/python).

phil
*** REPLY SEPARATOR ***

On 12.12.2000 at 10:25 Emmon Simbo wrote:
Hi

I have a few customers who are using Zope and have shown an interest in
using the OpenLink ODBC Drivers. Unfortunately, I am not familiar with Zope
and wondered if there was a How-To that I can use to show me how to use Zope
with ODBC. I have downloaded the ZmxODBCDA module but when I select this
from the Products menu, it shows up as ZmxODBCDA(Broken product ZmxODBCA).
If I click on the link, I get


  File "D:\APPS\ZopeWeb\lib\python\OFS\Application.py", line 397, in
import_products
product=__import__(pname, global_dict, global_dict, silly)
  File "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\__init__.py", line 91,
in ?
import DA
  File "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\DA.py", line 92, in ?
from db import DB, manage_ODBCDataSources
  File "D:\PROGRA~1\Zope22\lib\python\Products\ZmxODBCDA\db.py", line 87, in
?
ImportError: No module named mx.ODBC



Any ideas what's wrong here and secondly how I can go about making an ODBC
connection.

Thanks for you help in advance

Best Regards,

Emmon Simbo
Consultant
OpenLink Software
Tel: +44 (0) 20 8681 7701
Web: http://www.openlinksw.com
XML  E-Business Infrastructure Technology Provider



___
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

2000-12-12 Thread Emmon Simbo



Hi 
Paolo

I 
already have that. The problem was that it wasn't in the lib/python path. Moving 
it there fixed the problem. Now I get an error

Error Type: NameErrorError 
Value: SQLDataSources
whenI try to add a new 
datasource.

Emmon
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Paolo QuagliaSent: 12 
December 2000 11:12To: [EMAIL PROTECTED]Subject: RE: [Zope] 
ODBC Connection
Try to 
use the ZODBCDA 
http://www.zope.org/Products/DA/ZODBCDA


It 
works very well!

Paolo 
Quaglia


  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Emmon SimboSent: 
  Tuesday, December 12, 2000 11:26 AMTo: 
  [EMAIL PROTECTED]Subject: [Zope] ODBC Connection
  Hi 
  
  I have a few 
  customers who are using Zope and have shown an interest inusing 
  the 
  OpenLink ODBC Drivers. Unfortunately, I am not familiar with Zope and wondered 
  if there was a How-To that I can use to show me how to use Zope with ODBC. I 
  have downloaded the ZmxODBCDA module but when I select this from the Products 
  menu, it shows up as ZmxODBCDA(Brokenproduct ZmxODBCA). If I click on 
  the link, I get
  
   File 
  "D:\APPS\ZopeWeb\lib\python\OFS\Application.py", line 397, in 
  import_products product=__import__(pname, global_dict, 
  global_dict, silly) File 
  "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\__init__.py", line 91, in 
  ? import DA File 
  "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\DA.py", line 92, in 
  ? from db import DB, manage_ODBCDataSources 
  File "D:\PROGRA~1\Zope22\lib\python\Products\ZmxODBCDA\db.py", line 87, in 
  ?ImportError: No module named mx.ODBC
  
  Any ideas what's 
  wrong here and secondly how I can go about making an ODBC 
  connection.
  
  Thanks for you 
  help in advance
  
  Best Regards,
  
  Emmon SimboConsultantOpenLink 
  SoftwareTel: +44 (0) 20 8681 7701Web: http://www.openlinksw.comXML  E-Business Infrastructure Technology Provider 
  
  


RE: [Zope] ODBC Connection

2000-12-12 Thread Paolo Quaglia



Hi 
Emmon
I 
don't well understandthe exact moment the error 
occurs:

If you 
correctly havetheZODBCDA entry in the product list, you should have 
a new entry in the available objects list.
Now 
you have to create a new datasource with the win32 ODBC manager (in control 
panel).
thengo to a folder and add a new ZODBC Database 
connection and chose the created ODBC Datasorce

for me 
this work well ... 
Let me 
know

Paolo 
Quaglia

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Emmon SimboSent: 
  Tuesday, December 12, 2000 1:19 PMTo: Paolo Quaglia; 
  [EMAIL PROTECTED]Subject: RE: [Zope] ODBC 
  Connection
  Hi 
  Paolo
  
  I 
  already have that. The problem was that it wasn't in the lib/python path. 
  Moving it there fixed the problem. Now I get an error
  
  Error Type: 
  NameErrorError Value: 
  SQLDataSources
  whenI try to add a new 
  datasource.
  
  Emmon
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Paolo QuagliaSent: 
  12 December 2000 11:12To: [EMAIL PROTECTED]Subject: RE: 
  [Zope] ODBC Connection
  Try 
  to use the ZODBCDA 
  http://www.zope.org/Products/DA/ZODBCDA
  
  
  It 
  works very well!
  
  Paolo Quaglia
  
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Emmon SimboSent: 
Tuesday, December 12, 2000 11:26 AMTo: 
[EMAIL PROTECTED]Subject: [Zope] ODBC Connection
Hi 

I have a few 
customers who are using Zope and have shown an interest inusing 
the 
OpenLink ODBC Drivers. Unfortunately, I am not familiar with Zope and 
wondered if there was a How-To that I can use to show me how to use Zope 
with ODBC. I have downloaded the ZmxODBCDA module but when I select this 
from the Products menu, it shows up as ZmxODBCDA(Brokenproduct 
ZmxODBCA). If I click on the link, I get

 File 
"D:\APPS\ZopeWeb\lib\python\OFS\Application.py", line 397, in 
import_products product=__import__(pname, global_dict, 
global_dict, silly) File 
"D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\__init__.py", line 91, in 
? import DA File 
"D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\DA.py", line 92, in 
? from db import DB, manage_ODBCDataSources 
File "D:\PROGRA~1\Zope22\lib\python\Products\ZmxODBCDA\db.py", line 87, in 
?ImportError: No module named mx.ODBC

Any ideas what's 
wrong here and secondly how I can go about making an ODBC 
connection.

Thanks for you 
help in advance

Best Regards,

Emmon 
SimboConsultantOpenLink SoftwareTel: +44 (0) 20 8681 
7701Web: http://www.openlinksw.comXML  E-Business Infrastructure Technology 
Provider 



RE: [Zope] ODBC Connection

2000-12-12 Thread Emmon Simbo



Hi

Thx 
for the quick reply.

I already have several Datasources in my 
ODBC control Panel, is there something that I need to do to ensure that it picks 
up a Datasource from this list. All I have done install both Zope and the 
ZODBCDA module,go to the management screen and tried adding a new Z mxODBC 
connection. Is there something I'm missing here


Thanks

Emmon
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Paolo QuagliaSent: 12 
December 2000 13:15To: [EMAIL PROTECTED]Subject: RE: [Zope] 
ODBC Connection
Hi 
Emmon
I 
don't well understandthe exact moment the error 
occurs:

If you 
correctly havetheZODBCDA entry in the product list, you should have 
a new entry in the available objects list.
Now 
you have to create a new datasource with the win32 ODBC manager (in control 
panel).
thengo to a folder and add a new ZODBC Database 
connection and chose the created ODBC Datasorce

for me 
this work well ... 
Let me 
know

Paolo 
Quaglia

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Emmon SimboSent: 
  Tuesday, December 12, 2000 1:19 PMTo: Paolo Quaglia; 
  [EMAIL PROTECTED]Subject: RE: [Zope] ODBC 
  Connection
  Hi 
  Paolo
  
  I 
  already have that. The problem was that it wasn't in the lib/python path. 
  Moving it there fixed the problem. Now I get an error
  
  Error Type: 
  NameErrorError Value: 
  SQLDataSources
  whenI try to add a new 
  datasource.
  
  Emmon
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Paolo QuagliaSent: 
  12 December 2000 11:12To: [EMAIL PROTECTED]Subject: RE: 
  [Zope] ODBC Connection
  Try 
  to use the ZODBCDA 
  http://www.zope.org/Products/DA/ZODBCDA
  
  
  It 
  works very well!
  
  Paolo Quaglia
  
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Emmon SimboSent: 
Tuesday, December 12, 2000 11:26 AMTo: 
[EMAIL PROTECTED]Subject: [Zope] ODBC Connection
Hi 

I have a few 
customers who are using Zope and have shown an interest inusing 
the 
OpenLink ODBC Drivers. Unfortunately, I am not familiar with Zope and 
wondered if there was a How-To that I can use to show me how to use Zope 
with ODBC. I have downloaded the ZmxODBCDA module but when I select this 
from the Products menu, it shows up as ZmxODBCDA(Brokenproduct 
ZmxODBCA). If I click on the link, I get

 File 
"D:\APPS\ZopeWeb\lib\python\OFS\Application.py", line 397, in 
import_products product=__import__(pname, global_dict, 
global_dict, silly) File 
"D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\__init__.py", line 91, in 
? import DA File 
"D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\DA.py", line 92, in 
? from db import DB, manage_ODBCDataSources 
File "D:\PROGRA~1\Zope22\lib\python\Products\ZmxODBCDA\db.py", line 87, in 
?ImportError: No module named mx.ODBC

Any ideas what's 
wrong here and secondly how I can go about making an ODBC 
connection.

Thanks for you 
help in advance

Best Regards,

Emmon 
SimboConsultantOpenLink SoftwareTel: +44 (0) 20 8681 
7701Web: http://www.openlinksw.comXML  E-Business Infrastructure Technology 
Provider 



[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 )