[Zope] - Zope/ODBC and MS Sql Server 6.5 connection

Anthony Baxter anthony@interlink.com.au
Fri, 08 Jan 1999 20:48:41 +1100


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