Problem with TZConnection and MSSQL

marco.giacinti · Post by **marco.giacinti** » 01.04.2006, 14:39

Greetings to evrybody !!!
I'm in trouble: I wrote a standard Windows application using ZeosLib to connect to a MSSQL db and everything works; if I try to use the same piece of code in a Windows service my app hangs.
This behaviour is strange because even in services I'm able to let ZeosLib connect to MySQL for example.
So, the problem could be the fact I'm in a service (in EXE it works) but in the same service with the same TZConnection I'm able to connect to MySQL.

Can anybody help me please?
Thanks guys !!

zippo · Post by **zippo** » 01.04.2006, 18:49

Could be a some kind of privileges problem? Doesn't MSSQL accept only logged users (and your service are logged in as System)?

marco.giacinti · Post by **marco.giacinti** » 02.04.2006, 09:00

Well, I tried to configure service using Administrator account and let the service run when I was logged on... the same bad result

nego · Post by **nego** » 12.04.2006, 12:28

marco.giacinti wrote:Well, I tried to configure service using Administrator account and let the service run when I was logged on... the same bad result

Hi Marco!
Could you solve the problem with connection to MSSQL from Windows service? I can't understand why it does not work.

Zeoslib Portal

Problem with TZConnection and MSSQL

Problem with TZConnection and MSSQL

Question