[Zope] RE: SQL connection needed

Sean Kelley Sean.Kelley@epc1.com
Wed, 27 Oct 1999 14:32:19 -0700


My situation:

> I am trying to find out  what Zope is all about and trying to 
> make a simple
> database query from MS 
> SQL 6.5 (or anything else if I knew how).  When I go to add 
> SQL method it
> tells me I need an 
> SQL connection.  I downloaded:  ZODBC Database Adapter  3.1.0b2
> (Development)   and b1 
> and put then both in the site folder and the Zserver folder 
> and restarted
> the Zserver (I am on 
> windows 98)
> I still cannot add the SQL method.  Is there another product 
> I should be
> using?  I am fairly green 
> with SQL (I just write SQL based reports in reporting software)

THEN I tried the following after these instructions were provided:

o  reintall Zope
o  extract ZODBCDA to into the root of the Zope installation (i.e., if
you installed ZOpe into c:\zope then extract the ZODBCDA.tgx file into
c:\zope.
o  visit the Zope control panel and see if ZODBCDA shows up as a
product.

BUT, there is no "ZODBCDA.tgx" file.  The only file that comes with the ODBC
download (a gz file) is "ZODBC-3.1.0b2-win32.x86" there is no extension.
When I extract this file to the Zope folder I do not see ZODBCDA on the
products list on the control panel.

Any assistance would be GREATLY appreciated