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

[Vincent Joseph]

Hi,

I tried using a connection string - to no avail. I used the
Sybase connection string format, but that did not work. MS Sql
server does not have a connection string format listed in the
Aqueduct user guide - although as previously mentioned I did 
try:

DSN=ec;UID=userid;PWD=password;

That too failed.

Any thoughts/ideas?

Thanks,

Vincent

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]:
> >
> > <strong>Invalid connection string: </strong><CODE>ec</CODE><br>
> > <!--
> > sql.error
> > None
> > -->
> >
> > <!--
> > Traceback (innermost last):
> >   File C:\Program Files\zope19\lib\python\ZPublisher\Publish.py, line
> > 879, in publish_module
> >   File C:\Program Files\zope19\lib\python\ZPublisher\Publish.py, line
> > 595, in publish
> >     (Info: /Plutonia/manage_addZODBCConnection)
> >   File C:\Program Files\zope19\lib\python\Products\ZODBCDA\DA.py, line
> > 115, in manage_addZODBCConnection
> >     (Object: Navigation)
> >   File C:\Program
> > Files\zope19\lib\python\Shared\DC\ZRDB\Connection.py,
> > line 139, in __init__
> >     (Object: RoleManager)
> >   File C:\Program
> > Files\zope19\lib\python\Shared\DC\ZRDB\Connection.py,
> > line 168, in edit
> >     (Object: RoleManager)
> >   File C:\Program
> > Files\zope19\lib\python\Shared\DC\ZRDB\Connection.py,
> > line 212, in connect
> >     (Object: RoleManager)
> >   File C:\Program Files\zope19\lib\python\Products\ZODBCDA\db.py, line
> > 164, in __init__
> > BadRequest: (see above)
> >
> > -->
> >
> > I got the following from the SQL server books online, and tried both.
> > >>A minimum complete SQL Server connection string has one of
> > two forms:
> > >>DSN=dsnname;UID=loginid;PWD=password;
> > >>DRIVER={SQL Server};SERVER=server;UID=loginid;PWD=password;
> >
> > I also tried using the Sybase connection string pattern, to no avail.
> > So how do I go about specifying the user id and password to get
> > a successful login when using ODBC?
> >
> > Help would be much appreciated.
> >
> > Thanks in advance,
> >
> > Vincent
> >
> > --
> >
> >

-- 
It takes two to lie - one to lie and one to listen.  (Homer Simpson)