Thanks- I was trying to create the method under the ZSQL Methods product, not the ZODBCDA product I added. Is there a way to create a database connection to something like an MS Access database file when you cannot create the DSN on the server? I am thinking of using an Access file on a remote Zope ISP account.
-----Original Message----- From: Jim Sanford [mailto:jsanford@atinucleus.com] Sent: Friday, February 25, 2000 2:18 PM To: Sean Kelley; zope@zope.org Subject: Re: [Zope] ODBC/SQL newbie question
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 )