[Zope] ODBC/SQL newbie question

Sean Kelley Sean.Kelley@epc1.com
Fri, 25 Feb 2000 11:09:06 -0800


I am trying do begin working with MS SQL tables to display info.  I am very
new to 
SQL and my terminology might not be accurate so bear with me.

I noticed there is no SQL connector available for Microsoft so opted for the
ODBC 
Connector.  I have it all setup and can test it with a query successfully,
but I don't know 
how to write a query.  All of the instructions I see refer to using SQL
methods (I 
assume these are used with a SQL connector, not the ODBC Connector).
The reason I say this is when I select the "add a new SQL method" I get the
error:

Add a SQL Method

Warning: There are no SQL database connections. You need to add a Zope SQL 
database connection
before you can use a Zope SQL Method.

Any help would be greatly appreciated.

Sean Kelley
EPC Identification Systems/ Q-Cee's Product Corporation
Direct:  (707) 360-2347
Phone: (707) 575-3336 ext. 2347
Fax:     (707) 575-3337
www.epc1.com
www.q-cees.com