Page 1 of 1

Problem with TZConnection and MSSQL

Posted: 01.04.2006, 14:39
by marco.giacinti
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 !!

Posted: 01.04.2006, 18:49
by zippo
Could be a some kind of privileges problem? Doesn't MSSQL accept only logged users (and your service are logged in as System)?

Posted: 02.04.2006, 09:00
by marco.giacinti
Well, I tried to configure service using Administrator account and let the service run when I was logged on... the same bad result :(

Question

Posted: 12.04.2006, 12:28
by nego
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.