Hi, On winnt go to Control_Panel/Services/yourservice/startup/ and select a nt account to run the service with. Then in the odbc dsn if you choose to connect with a NT account the account you selected on the service will show in the profiler, if you choose a specific sql acount then that specific account should appear. Best Regards, Julio Silva

From: Luca Manini <manini@agenzialavoro.tn.it> Reply-To: Luca Manini AgeLav <manini@agenzialavoro.tn.it> To: zope@zope.org Subject: (fwd) Re: [Zope] Connecting to MS SQL Date: Tue, 29 May 2001 15:04:24 +0200

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

_______________________________________________ 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 )

_________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.