On Tue, 29 May 2001 13:31:56 +0200, Luca Manini <manini@agenzialavoro.tn.it> wrote: On Tue, 29 May 2001 13:19:21 +0200, you wrote:
Hi,
I'm trying to connect to a MS SQL (7) server. I read the note http://www.zope.org/Members/roberth/ZMSSQLServer and I followed all the steps. But I can't get connected (see error below).
I do check with MS SQL Profiler. When I check the connection from the ODBC Manager, or when I open the connection from Delphi, the correct UserName is send to the server. But when I add the connection from Zope, the UserName is empty!!! Help! Luca
On Tue, 29 May 2001 15:04:24 +0200, you wrote: I've done a step forward. Now I can connect by specifying the parameter of the connection in the edti box. The (stupid) error I was doing was to specify the name of the server instead of the name of the odbc connection. Example Server: S ODBC Connection: C User: U Password: P I was entering S U P instead of C U P. Even if Zope "hints" says: The database connection string is of the form: dsn user password where the data source name, user id, and password are separated by one or more spaces. I still do not understand why it does not work simply picking a connection from the list :-(
I do check with MS SQL Profiler. When I check the connection from the ODBC Manager, or when I open the connection from Delphi, the correct UserName is send to the server. But when I add the connection from Zope, the UserName is empty!!!
Help! Luca
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (1)
-
Luca Manini