[Zope] ODBC/SQL newbie question

[Jim Sanford]

After you have installed the ODBC Database Adapter product you need to define at least one (1) ODBC connection.

Select Z ODBC Database Connection from the dropdown list of available objects and then select a system dsn you have previously
created under the ODBC section in the Control Panel of the NT machine Zope is running on. Next add your username and password to the
database connection string. The database connection string should now look like this (without the quotes): "dsnname username
password".

You should now be able to create Z SQL methods.

 __________________________________________________________________

              Jim Sanford
      .       Database/Web Engineer
     / \  /   Accelerated Technology, Inc.
    /   /     720 Oak Circle Drive East
   /  /  \    Mobile, AL 36609
  / /     \   Voice: 334-661-5770  fax: 334-661-5788
 /         \  E-Mail: jsanford@atinucleus.com
              Web: http://www.atinucleus.com

 Source Code, No Royalties, Any CPU...It just make sense !
 __________________________________________________________________


Then you can create Z SQL methods
----- Original Message -----
From: Sean Kelley <Sean.Kelley@epc1.com>
To: <zope@zope.org>
Sent: Friday, February 25, 2000 1:09 PM
Subject: [Zope] ODBC/SQL newbie question


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

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