Click here to Skip to main content
       

Database

 
GeneralRe: Colin Angus Mackay ???? PinsussWDI22-Mar-05 11:34 
QuestionColin Angus Mackay ???? PinsussWDI22-Mar-05 10:08 
AnswerRe: Colin Angus Mackay ???? PinsussDavid Rawheiser23-Mar-05 10:18 
GeneralSql stored procedure vs triggers vs functions Pinmemberjinnyb22-Mar-05 6:55 
GeneralRe: Sql stored procedure vs triggers vs functions PinmemberColin Angus Mackay22-Mar-05 8:13 
GeneralRe: Sql stored procedure vs triggers vs functions Pinmemberjinnyb22-Mar-05 10:34 
GeneralRe: Sql stored procedure vs triggers vs functions PinmemberEdbert P.22-Mar-05 19:53 
GeneralADO inside win32 services goes boom PinmemberPeter Mares22-Mar-05 4:08 
Hi everyone,
 
I've wondered across a peculiar issue with ADO (although something else could be the culprit, but through my investigation, I believe it to be ADO).
 
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.
 
Basically, this is what I've found to happen:
 
1. I issue a connect() call, and it returns S_OK.
2. Immediately after that, I execute a simple query, say "select count(*) from table1". At this point, when running as a normal app, the query executes and all is well. However, as a service, the query fails. Upon further inspection, doing a check on whether the connection is actually "connected", I find that it is infact disconnected.
 
Any ideas? I've been thrashing my brains with this problem for a few hours now. Maybe someone can shed some light on this?
 
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?
 
Thanks,
Peter
 

controlSHIFT
[Glossary Manager] [AfterThought Backup Lite]

All good things were meant to be improved
GeneralRe: ADO inside win32 services goes boom PinmemberChris Austin22-Mar-05 18:25 
GeneralRe: ADO inside win32 services goes boom PinmemberPeter Mares22-Mar-05 20:51 
GeneralQuery Date Field Type In Access PinmemberAjibawo22-Mar-05 1:16 
GeneralRe: Query Date Field Type In Access PinmemberColin Angus Mackay22-Mar-05 8:14 
GeneralRe: Query Date Field Type In Access PinmemberEdbert P.22-Mar-05 19:55 
GeneralRe: Query Date Field Type In Access PinmemberAjibawo22-Mar-05 23:09 
GeneralRe: Query Date Field Type In Access PinmemberEdbert P.23-Mar-05 12:07 
GeneralPackage And Deployment Wizard PinmemberSalman.21-Mar-05 23:48 
GeneralRe: Package And Deployment Wizard Pinmemberrwestgraham22-Mar-05 11:58 
Generaldataset or datareader Pinmemberjinnyb21-Mar-05 21:41 
GeneralRe: dataset or datareader PinmemberColin Angus Mackay21-Mar-05 22:03 
QuestionWhich is faster? PinmemberYulianto AKA goodmast3r21-Mar-05 16:16 
AnswerRe: Which is faster? PinmemberChristian Graus21-Mar-05 16:32 
GeneralViewing stored procedures PinmemberIts due when21-Mar-05 3:58 
GeneralRe: Viewing stored procedures PinmemberColin Angus Mackay21-Mar-05 4:09 
GeneralRe: Viewing stored procedures PinmemberScott Serl21-Mar-05 11:22 
Generaldiff between managed providers and ole-db provider Pinmembersatishrg20-Mar-05 20:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.141223.1 | Last Updated 26 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid