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 )