Re: ADO and Win32 Services
From: Ross McKay (rosko_at_zeta.NOT.THIS.BIT.org.au)
Date: 03/25/05
- Next message: Chad: "Clone Recordset to new Recordset with Append.Fields"
- Previous message: cwahlmeier_at_data-tronics.com: "Re: ADO dates and '0001-01-01'"
- In reply to: me: "ADO and Win32 Services"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 25 Mar 2005 04:41:21 GMT
On Tue, 22 Mar 2005 16:17:17 +0200, Peter wrote:
>I have written a service that uses ADO. When running the service as a
>console app, everything works great. However, when the service is run 'as a
>service' in the SCM, I find a problem with the connection.
>...
>I have tried changing the account under which the service runs. That didn't
>work. I tried testing different data providers. Same problem. Anything else
>I can try?
I'm going to guess here that you are not ensuring that the connection is
being made as TCP/IP, and therefore could be a named pipe connection.
When you changed the account under which it runs, did you try a login
account that can connect to the server? (i.e. not just a local computer
account, if the server is on another computer)
Probably the easiest way to resolve would be to create an alias for your
server in the Client Network Utility, and specify TCP/IP. Alternatively,
specify TCP/IP as your network library in your connection string.
That's pretty much all I can think of. Good luck!
-- Ross McKay, Toronto, NSW Australia "There is more to life than simply increasing its speed." - Mahatma Gandhi
- Next message: Chad: "Clone Recordset to new Recordset with Append.Fields"
- Previous message: cwahlmeier_at_data-tronics.com: "Re: ADO dates and '0001-01-01'"
- In reply to: me: "ADO and Win32 Services"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
