Android Question How to Create a Service for Database Connection

[manuaaa]

Hi All,

I wants to create a background service to connect my MSSQL Database. Presently i connect it with below given codes in main activity:

Sub Process_Globals
Dim a As MSSQL
End Sub

Sub Activity_Create(FirstTime As Boolean)
a.setDatabase("xxx.xx.xxx.xxx","xxxxxxxx","xxxxx","LddIn#cdcdc")

End Sub

Is it possible to get the current location of app or device when the app is not in a running position. Actually right now when the app is stopped by user i can't get the location but when it starts i gets the location.

That's why i decide to run an extra background service through which i can send location even if the app is stopped by user..

Please help.

 

[DonManfred]

you can use the starter service for this

 

[manuaaa]

you can use the starter service for this

i know the things about starter service but how?? pl give some sample if possible, thanks

 

[Erel]

I recommend you to use JdbcSQL library.

You need to add a new service and make it a foreground service. You also need to acquire a partial wake lock (PhoneWakeState).