Click here to Skip to main content
14,697,992 members
Home » Discussions » C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: How to make a Windows service to manage SQLite DB Pin
intelstar venus2-Nov-15 6:20
Memberintelstar venus2-Nov-15 6:20 
GeneralRe: How to make a Windows service to manage SQLite DB Pin
Richard MacCutchan2-Nov-15 6:22
mveRichard MacCutchan2-Nov-15 6:22 
GeneralRe: How to make a Windows service to manage SQLite DB Pin
intelstar venus2-Nov-15 6:41
Memberintelstar venus2-Nov-15 6:41 
GeneralRe: How to make a Windows service to manage SQLite DB Pin
Richard MacCutchan2-Nov-15 7:25
mveRichard MacCutchan2-Nov-15 7:25 
GeneralRe: How to make a Windows service to manage SQLite DB Pin
intelstar venus2-Nov-15 7:44
Memberintelstar venus2-Nov-15 7:44 
QuestionRe: How to make a Windows service to manage SQLite DB Pin
David Crow2-Nov-15 10:14
MemberDavid Crow2-Nov-15 10:14 
AnswerRe: How to make a Windows service to manage SQLite DB Pin
intelstar venus2-Nov-15 22:28
Memberintelstar venus2-Nov-15 22:28 
AnswerRe: How to make a Windows service to manage SQLite DB Pin
jschell3-Nov-15 17:12
Memberjschell3-Nov-15 17:12 
Just noting that in general a windows service would not be used to "manage" a database.

A database might be a windows service (or more than one service.)

A management API would exist on one of those servers.
Then an application, not service, would use that API and present a interface, like a GUI, to a user. The interface could also be a command line console.

A service API that would support the above would support the following
1- A definition of a protocol, such as Rest or more generally http
2- Commands that are sent via the protocol and responses to those commands.
3- The API protocol would be a LAYER on top of the actual management code.
3a - Supporting 3 one should probably add logging.
4- Management layer.

At best from your code it looks something like 3. I suggest you look into learning how to use a logging API.

Additionally there are other aspects involved with getting a windows service to run, and those have nothing to do with the actual database problem. For example
A- Starting/stopping the service
B- Running with the correct user


Member 11967800 wrote:
If I give a static command such as "select * from my_settings" instead of sQuery.c_str(), it operated properly, but it doesn't act when it receives a dynamic params.


That doesn't have anything to do with windows service. It has to do with how you implemented the code. At best this looks like 4 above and you should get it that to work BEFORE you attempt to do anything else.
GeneralRe: How to make a Windows service to manage SQLite DB Pin
intelstar venus4-Nov-15 2:05
Memberintelstar venus4-Nov-15 2:05 
GeneralRe: How to make a Windows service to manage SQLite DB Pin
jschell7-Nov-15 5:58
Memberjschell7-Nov-15 5:58 
Questionsocket:send integer Pin
Member 114755491-Nov-15 5:51
MemberMember 114755491-Nov-15 5:51 
QuestionRe: socket:send integer Pin
Richard MacCutchan1-Nov-15 6:36
mveRichard MacCutchan1-Nov-15 6:36 
AnswerRe: socket:send integer Pin
Member 114755496-Nov-15 5:15
MemberMember 114755496-Nov-15 5:15 
GeneralRe: socket:send integer Pin
Richard MacCutchan6-Nov-15 5:17
mveRichard MacCutchan6-Nov-15 5:17 
AnswerRe: socket:send integer Pin
Jochen Arndt1-Nov-15 22:07
professionalJochen Arndt1-Nov-15 22:07 
GeneralRe: socket:send integer Pin
Member 114755496-Nov-15 5:16
MemberMember 114755496-Nov-15 5:16 
Questionuint32_t result of uint16_t addition Pin
elelont230-Oct-15 4:44
Memberelelont230-Oct-15 4:44 
AnswerRe: uint32_t result of uint16_t addition Pin
Jochen Arndt30-Oct-15 5:00
professionalJochen Arndt30-Oct-15 5:00 
AnswerRe: uint32_t result of uint16_t addition Pin
jeron130-Oct-15 5:08
Memberjeron130-Oct-15 5:08 
AnswerRe: uint32_t result of uint16_t addition Pin
CPallini30-Oct-15 5:24
mveCPallini30-Oct-15 5:24 
AnswerRe: uint32_t result of uint16_t addition Pin
R. Erasmus4-Nov-15 0:48
MemberR. Erasmus4-Nov-15 0:48 
QuestionChange menu item text Pin
_Flaviu29-Oct-15 4:25
Member_Flaviu29-Oct-15 4:25 
AnswerRe: Change menu item text Pin
Richard MacCutchan29-Oct-15 6:20
mveRichard MacCutchan29-Oct-15 6:20 
GeneralRe: Change menu item text Pin
_Flaviu5-Nov-15 2:29
Member_Flaviu5-Nov-15 2:29 
GeneralRe: Change menu item text Pin
Richard MacCutchan5-Nov-15 6:32
mveRichard MacCutchan5-Nov-15 6:32 

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.