RE: [Zope] - Zope/ODBC and MS Sql Server 6.5 connection
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
--
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)
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
Anthony Baxter wrote:
I'm in a similar situation to Vincent (yes, his original email was about 3 weeks ago).
I'm working with Vincent and Arpad on chasing this down. It appears the the connection calls made from, ZODBCDA are getting confused by SQL_SUCCESS_WITH_INFO returns. Stay tuned. BTW, the same sql extension is used in both ZODBCDA abd ZSolidDA, http://www.zope.org/Download/ZSolidDA. If anyone wants to investigate this at the C level, they can find the source in the ZSolidDA release. Jim -- Jim Fulton mailto:jim@digicool.com Technical Director (540) 371-6909 Python Powered! Digital Creations http://www.digicool.com http://www.python.org Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.
participants (4)
-
Anthony Baxter -
Jim Fulton -
Paul Everitt -
Vincent Joseph