Click here to Skip to main content
15,894,405 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 5:20
intelstar venus2-Nov-15 5:20 
GeneralRe: How to make a Windows service to manage SQLite DB Pin
Richard MacCutchan2-Nov-15 5:22
mveRichard MacCutchan2-Nov-15 5:22 
GeneralRe: How to make a Windows service to manage SQLite DB Pin
intelstar venus2-Nov-15 5:41
intelstar venus2-Nov-15 5:41 
GeneralRe: How to make a Windows service to manage SQLite DB Pin
Richard MacCutchan2-Nov-15 6:25
mveRichard MacCutchan2-Nov-15 6:25 
GeneralRe: How to make a Windows service to manage SQLite DB Pin
intelstar venus2-Nov-15 6:44
intelstar venus2-Nov-15 6:44 
QuestionRe: How to make a Windows service to manage SQLite DB Pin
David Crow2-Nov-15 9:14
David Crow2-Nov-15 9:14 
AnswerRe: How to make a Windows service to manage SQLite DB Pin
intelstar venus2-Nov-15 21:28
intelstar venus2-Nov-15 21:28 
AnswerRe: How to make a Windows service to manage SQLite DB Pin
jschell3-Nov-15 16:12
jschell3-Nov-15 16: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 1:05
intelstar venus4-Nov-15 1:05 
GeneralRe: How to make a Windows service to manage SQLite DB Pin
jschell7-Nov-15 4:58
jschell7-Nov-15 4:58 
Questionsocket:send integer Pin
Member 114755491-Nov-15 4:51
Member 114755491-Nov-15 4:51 
QuestionRe: socket:send integer Pin
Richard MacCutchan1-Nov-15 5:36
mveRichard MacCutchan1-Nov-15 5:36 
AnswerRe: socket:send integer Pin
Member 114755496-Nov-15 4:15
Member 114755496-Nov-15 4:15 
GeneralRe: socket:send integer Pin
Richard MacCutchan6-Nov-15 4:17
mveRichard MacCutchan6-Nov-15 4:17 
AnswerRe: socket:send integer Pin
Jochen Arndt1-Nov-15 21:07
professionalJochen Arndt1-Nov-15 21:07 
GeneralRe: socket:send integer Pin
Member 114755496-Nov-15 4:16
Member 114755496-Nov-15 4:16 
Questionuint32_t result of uint16_t addition Pin
elelont230-Oct-15 3:44
elelont230-Oct-15 3:44 
AnswerRe: uint32_t result of uint16_t addition Pin
Jochen Arndt30-Oct-15 4:00
professionalJochen Arndt30-Oct-15 4:00 
AnswerRe: uint32_t result of uint16_t addition Pin
jeron130-Oct-15 4:08
jeron130-Oct-15 4:08 
AnswerRe: uint32_t result of uint16_t addition Pin
CPallini30-Oct-15 4:24
mveCPallini30-Oct-15 4:24 
AnswerRe: uint32_t result of uint16_t addition Pin
R. Erasmus3-Nov-15 23:48
R. Erasmus3-Nov-15 23:48 
QuestionChange menu item text Pin
_Flaviu29-Oct-15 3:25
_Flaviu29-Oct-15 3:25 
AnswerRe: Change menu item text Pin
Richard MacCutchan29-Oct-15 5:20
mveRichard MacCutchan29-Oct-15 5:20 
GeneralRe: Change menu item text Pin
_Flaviu5-Nov-15 1:29
_Flaviu5-Nov-15 1:29 
GeneralRe: Change menu item text Pin
Richard MacCutchan5-Nov-15 5:32
mveRichard MacCutchan5-Nov-15 5: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.