[Zope] newbie question

[Anthony Pfrunder]

On Mon, 16 Aug 1999, Martin van Nijnatten wrote:

> How can I create an ODBC database connection with a SQL Server database?
> 
> Platform: Win98

Hi!,
I haven't used ODBC for SQL Server but have used it for Excel
spreadsheets.  The process is:

	* Upgrade OBDC to the latest drivers
	* Go to OBDC32 in your Windows Control Panel and add a connection
	  to SQL Server.
	* Start Zope 2
	* Ensure ODBC product is ok (check in Control
Panel/Products/ZODBC)
	* Add an SQL Connection
	* Add an zODBC instance
	* Select your instance and turn it on
	* Select zODBC instance in the SQL connection list
	* Query away!

The reason that you cannot query zODBC directly is that the SQL connection
provides a standard interface to all database adaptors.
 
> Martin

Cheers,

Anthony Pfrunder