[Zope] Connecting to MS SQL

Luca Manini Luca Manini AgeLav <manini@agenzialavoro.tn.it>
Tue, 29 May 2001 13:19:21 +0200


Hi,=20

I'm trying to connect to a MS SQL (7) server.=20
I read the note http://www.zope.org/Members/roberth/ZMSSQLServer
and I followed all the steps.=20
But I can't get connected (see error below).=20
Other ODBC connections do work (to MDB files).=20
The ODBC Manager seems to be happy with the configuration.=20
And the connection do work with Delphi.=20

Any hint ?
Any "strange" constraint (case sensitive, ...)

Set up is:=20

NT4
MS SQL 7 (on another NT 4 machine)
Zope Version  Zope 2.3.2 (binary release, python 1.5.2, win32-x86) =20
Python Version  1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)]
System Platform  win32 =20

	TIA, Luca.=20








Traceback (innermost last):
  File C:\Programmi\Zope\lib\python\ZPublisher\Publish.py, line 223,
in publish_module
  File C:\Programmi\Zope\lib\python\ZPublisher\Publish.py, line 187,
in publish
  File C:\PROGRA~1\Zope\lib\python\Zope\__init__.py, line 221, in
zpublisher_exception_hook
    (Object: Traversable)
  File C:\Programmi\Zope\lib\python\ZPublisher\Publish.py, line 171,
in publish
  File C:\PROGRA~1\Zope\lib\python\ZPublisher\mapply.py, line 160, in
mapply
    (Object: manage_addZODBCConnection)
  File C:\Programmi\Zope\lib\python\ZPublisher\Publish.py, line 112,
in call_object
    (Object: manage_addZODBCConnection)
  File C:\Programmi\Zope\lib\python\Products\ZODBCDA\DA.py, line 104,
in manage_addZODBCConnection
    (Object: Traversable)
  File C:\PROGRA~1\Zope\lib\python\Shared\DC\ZRDB\Connection.py, line
132, in __init__
    (Object: RoleManager)
  File C:\PROGRA~1\Zope\lib\python\Shared\DC\ZRDB\Connection.py, line
161, in edit
    (Object: RoleManager)
  File C:\PROGRA~1\Zope\lib\python\Shared\DC\ZRDB\Connection.py, line
240, in connect
    (Object: RoleManager)
  File C:\Programmi\Zope\lib\python\Products\ZODBCDA\db.py, line 155,
in __init__
BadRequest: (see above)