[Zope] Problems with zope + MS SQL Server

[Robert Honore]

Anyone ever figured out how to get ZOPE's ODBC DA to work with MS SQL Server?

I am a Zope newbie using MS SQL Server 7.0, Zope version 2.1.6, Python 1.5.2 Win
386 and ZODBC
Version 3.1.0b2.

Whenever I attempt to open an ODBC connection to the SQL Server I get the
message "Invalid connection string:" followed by the name of the DSN I am trying
to use.  Can anyone help me along with this or is this the curse for using
Microsoft software?

Yours sincerely,
Robert Honore.