Click here to Skip to main content
12,510,369 members (49,448 online)
   

Database

 
GeneralRe: Row ID after INSERT to database Pin
Jeff Martin24-Mar-05 4:06
memberJeff Martin24-Mar-05 4:06 
GeneralRe: Row ID after INSERT to database Pin
Jeff Martin24-Mar-05 3:15
memberJeff Martin24-Mar-05 3:15 
GeneralRe: Row ID after INSERT to database Pin
Abyss24-Mar-05 3:45
memberAbyss24-Mar-05 3:45 
GeneralRe: Row ID after INSERT to database Pin
Jeff Martin24-Mar-05 4:08
memberJeff Martin24-Mar-05 4:08 
QuestionColin Angus Mackay ???? Pin
WDI22-Mar-05 9:11
sussWDI22-Mar-05 9:11 
AnswerRe: Colin Angus Mackay ???? Pin
Jeff Martin22-Mar-05 9:57
memberJeff Martin22-Mar-05 9:57 
GeneralRe: Colin Angus Mackay ???? Pin
WDI22-Mar-05 10:34
sussWDI22-Mar-05 10:34 
QuestionColin Angus Mackay ???? Pin
WDI22-Mar-05 9:08
sussWDI22-Mar-05 9:08 
AnswerRe: Colin Angus Mackay ???? Pin
David Rawheiser23-Mar-05 9:18
sussDavid Rawheiser23-Mar-05 9:18 
GeneralSql stored procedure vs triggers vs functions Pin
jinnyb22-Mar-05 5:55
memberjinnyb22-Mar-05 5:55 
GeneralRe: Sql stored procedure vs triggers vs functions Pin
Colin Angus Mackay22-Mar-05 7:13
memberColin Angus Mackay22-Mar-05 7:13 
GeneralRe: Sql stored procedure vs triggers vs functions Pin
jinnyb22-Mar-05 9:34
memberjinnyb22-Mar-05 9:34 
GeneralRe: Sql stored procedure vs triggers vs functions Pin
Edbert P.22-Mar-05 18:53
memberEdbert P.22-Mar-05 18:53 
GeneralADO inside win32 services goes boom Pin
Peter Mares22-Mar-05 3:08
memberPeter Mares22-Mar-05 3: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 Pin
Chris Austin22-Mar-05 17:25
memberChris Austin22-Mar-05 17:25 
GeneralRe: ADO inside win32 services goes boom Pin
Peter Mares22-Mar-05 19:51
memberPeter Mares22-Mar-05 19:51 
GeneralQuery Date Field Type In Access Pin
Ajibawo22-Mar-05 0:16
memberAjibawo22-Mar-05 0:16 
GeneralRe: Query Date Field Type In Access Pin
Colin Angus Mackay22-Mar-05 7:14
memberColin Angus Mackay22-Mar-05 7:14 
GeneralRe: Query Date Field Type In Access Pin
Edbert P.22-Mar-05 18:55
memberEdbert P.22-Mar-05 18:55 
GeneralRe: Query Date Field Type In Access Pin
Ajibawo22-Mar-05 22:09
memberAjibawo22-Mar-05 22:09 
GeneralRe: Query Date Field Type In Access Pin
Edbert P.23-Mar-05 11:07
memberEdbert P.23-Mar-05 11:07 
GeneralPackage And Deployment Wizard Pin
Salman.21-Mar-05 22:48
memberSalman.21-Mar-05 22:48 
GeneralRe: Package And Deployment Wizard Pin
rwestgraham22-Mar-05 10:58
memberrwestgraham22-Mar-05 10:58 
Generaldataset or datareader Pin
jinnyb21-Mar-05 20:41
memberjinnyb21-Mar-05 20:41 
GeneralRe: dataset or datareader Pin
Colin Angus Mackay21-Mar-05 21:03
memberColin Angus Mackay21-Mar-05 21:03 
QuestionWhich is faster? Pin
Yulianto AKA goodmast3r21-Mar-05 15:16
memberYulianto AKA goodmast3r21-Mar-05 15:16 
AnswerRe: Which is faster? Pin
Christian Graus21-Mar-05 15:32
memberChristian Graus21-Mar-05 15:32 
GeneralViewing stored procedures Pin
Its due when21-Mar-05 2:58
memberIts due when21-Mar-05 2:58 
GeneralRe: Viewing stored procedures Pin
Colin Angus Mackay21-Mar-05 3:09
memberColin Angus Mackay21-Mar-05 3:09 
GeneralRe: Viewing stored procedures Pin
Scott Serl21-Mar-05 10:22
memberScott Serl21-Mar-05 10:22 
Generaldiff between managed providers and ole-db provider Pin
satishrg20-Mar-05 19:16
membersatishrg20-Mar-05 19:16 
GeneralRe: diff between managed providers and ole-db provider Pin
Colin Angus Mackay21-Mar-05 3:12
memberColin Angus Mackay21-Mar-05 3:12 
Generalthank you very much Pin
satishrg21-Mar-05 10:48
membersatishrg21-Mar-05 10:48 
GeneralMSDE won't install Pin
Christian Graus20-Mar-05 17:36
memberChristian Graus20-Mar-05 17:36 
GeneralDB Small Footprint (Access? Firebird?) Pin
Dato20-Mar-05 7:19
memberDato20-Mar-05 7:19 
GeneralRe: DB Small Footprint (Access? Firebird?) Pin
salsafyren221-Mar-05 0:08
membersalsafyren221-Mar-05 0:08 
GeneralRe: DB Small Footprint (Access? Firebird?) Pin
Luis Alonso Ramos23-Mar-05 20:43
memberLuis Alonso Ramos23-Mar-05 20:43 
Questionsuggest me a good book ? Pin
WDI19-Mar-05 22:18
sussWDI19-Mar-05 22:18 
AnswerRe: suggest me a good book ? Pin
Andy MacAngus21-Mar-05 9:25
memberAndy MacAngus21-Mar-05 9:25 
GeneralGenericOLEDB Pin
sjurmr19-Mar-05 11:20
membersjurmr19-Mar-05 11:20 
GeneralSQL database protection Pin
Wimal Prasanna19-Mar-05 4:39
memberWimal Prasanna19-Mar-05 4:39 
GeneralRe: SQL database protection Pin
Colin Angus Mackay19-Mar-05 10:32
memberColin Angus Mackay19-Mar-05 10:32 
GeneralRe: SQL database protection Pin
Mike Dimmick19-Mar-05 23:08
memberMike Dimmick19-Mar-05 23:08 
GeneralOR mapping tools And Object Broker pattern Pin
norm19-Mar-05 2:51
membernorm19-Mar-05 2:51 
GeneralSoundex In Ado.net Dataset Search Pin
Hemant_Mane18-Mar-05 22:41
memberHemant_Mane18-Mar-05 22:41 
QuestionIIS Webhits via ADO.NET? Pin
harryteck18-Mar-05 13:39
memberharryteck18-Mar-05 13:39 
GeneralINNER JOIN Pin
HahnTech18-Mar-05 9:00
sussHahnTech18-Mar-05 9:00 
GeneralRe: INNER JOIN Pin
HahnTech18-Mar-05 10:22
memberHahnTech18-Mar-05 10:22 
QuestionCan someone give me an advise for my application's database Pin
Blue_Skye18-Mar-05 6:31
memberBlue_Skye18-Mar-05 6:31 
QuestionWhich is better on webservice? Pin
WDI18-Mar-05 0:27
sussWDI18-Mar-05 0:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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
Web02 | 2.8.160929.1 | Last Updated 29 Sep 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid