I'm in a similar situation to Vincent (yes, his original email was about 3 weeks ago). Paul's advice to look at the connection string doesn't seem to help, since there is no entry in the table for MS SQL Server. The sybase format doesn't seem to do the trick. Anyone able to help here? Anthony Paul Everitt wrote:
Instead of picking the ODBC connection from the select list, type in a connection string in the box below it. Connection string sytax is pretty baroque. Check out Table 1, "Connection String Formats" in the Aqueduct Manager's Guide.
--Paul
-----Original Message----- From: Vincent Joseph [mailto:vincent.joseph@usa.net] Sent: Thursday, December 24, 1998 8:15 AM To: zope@zope.org Subject: [Zope] - Zope/ODBC and MS Sql Server 6.5 connection
Hi,
Has anyone managed to connect to MS SQL Server 6.5 using Zope ODBC? The ODBC Data Source Administrator does not have a place where you can specify a user/id and password. So selecting the data source does not seem to be enough. The clients that I use (isqlw) always ask for a userid and password. How do I provide this information to Zope, while at the same time using ODBC? When I try to connect it gives me the following message [ec is my data source name]:
-- Anthony Baxter, NextTelecom. email:anthony@interlink.com.au, voice: +61 416 271 170