Page 1 of 1
Cannot Connect to database in service application
Posted: Fri 13 Aug 2010 11:13
by pithakse
Hi,
I have problem on connect to sql-server in service application.
The error are time-out.
But if I try with the same code in IDE it work fine.
My Delphi is v 6.02
and dbexpress driver Version 4.45.18 (04-Sep-2009)
Please advise
Thank you in advance
Posted: Fri 13 Aug 2010 12:31
by Dimon
To solve the problem try to set the TSQLConnection.LoginPrompt property to False.
Posted: Sat 14 Aug 2010 04:54
by pithakse
Thank you for your reply.
May be my bad luck, the problem stll unsolve.
Posted: Mon 16 Aug 2010 09:33
by Dimon
Please specify the exact error message that arises in your application.
Posted: Wed 18 Aug 2010 11:56
by pithakse
Very sorry for late reply. Now I am on the way traveling.
When I back to office I will give you more detail.
Thank you
Best regards
Pithakse
Posted: Fri 07 Jan 2011 22:42
by martin
Make sure you are not using Windows Logon Authentication in SQL Server but use SQL Server Authentication. Windows Services often run under very restricted Accounts and therefore it is possible that your Account does not have the credentials to access the SQL Server by Windows Authentication.
We are using dbExpressin our Services with no problems, well at least no Logon problems..