[Zope] Creating a Database connection.

Farrell, Troy troy.farrell@wilcom.com
Tue, 9 Jan 2001 15:32:42 -0600


We need more specific information to help you.  I'll give you an example:

I run one zope installation on Windows NT 4.0SP6.
I use PostgreSQL 7.0.3 on WindowsNT with Cygwin.

1)install Zope
2)compile PostgreSQL with ODBC support and install it
3)install ZODBCDA (Zope ODBC Database adapter)
4)install psqlodbc.dll to enable Windows ODBC to connect to Postgres through
ODBC
5)add an ODBC connection to PostgreSQL through the Windows Control Panel
6)Start Zope and login as a Manager
7)Add a ZODBCDA connection through the drop-down box at the bottom.
7a)select your new-fangled ODBC connection as the connect string
8)select the test tab of your connection object to test the connection
9)create a new ZSQL method to use your connection

See...Easier than a 12-step program

Troy

-----Original Message-----
From: Spicklemire, Jerry [mailto:Jerry.Spicklemire@IFLYATA.COM]
Sent: Saturday, January 06, 2001 3:49 PM
To: 'darren.carney@RevolutionLtd.com'
Cc: 'zope@zope.org'
Subject: [Zope] Creating a Database connection.


Darren wrote:

> I am very new to the Zope idea. I like what Zope is trying  
> to do. But I am trying to set up an external SQL database 
> connection

While it would be ideal for one set of instructions to serve 
every possible requirement, in reality it will be best for 
you to provide as much detail as you can about the specific 
scenario you are facing.

For starters:

What Operating System will Zope be hosted on?

What Database "backend" do you need to connect to?

Will the Database be resident on the same system as Zope?

If not, what Operating System will be hosting the Database?

Get back to the list with the answers, and anything else you 
think might help, plus what you have already tried, that 
hasn't worked.

Later,
Jerry S.

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