Android Question Remote Database Connection to maintain or not?

Jakes72 · Feb 10, 2020

Hi to all the Experts,

Just a quick question.
I am connecting to a MS SQL database on a remote Server using the JdbcSQL driver.
Now is it better to establish a connection at the start of my app and maintain the connection, or is it better to connect and disconnect everytime I do a query/non query?

Thank you for your time,
Regards Jacques.

Erel · Feb 10, 2020

Best option is to use jRDC2 instead of connecting to the database directly.

It is not so simple to maintain an active connection. I recommend you to connect and disconnect each time, however it also depends on your app requirements.

Jakes72 · Feb 10, 2020

Thank you for your reply Erel I appreciate it.
What would the connection string look like using jRDC2 if I wanted to connect to an MS SQL database?

josejad · Feb 10, 2020

Based on:

jRDC2 MSSQL getting error fetching connection when connecting

Hi Erel and Expert guys out there, Getting error fetching connection when connecting to mssql server using b4j web server app. I can able to connect using mysql but for mssql using the jtds-1.3.1 library I cannot figured it out. B4j: #AdditionalJar: jtds-1.3.1 config.properties #example of...

www.b4x.com

It should be something like:

B4X:

JdbcUrl=jdbc:jtds:sqlserver://127.0.0.1/test

supposing your jRDC2 server is on the same MS SQL server

Note that if you want to use jRDC2, you should have a VPS.

Android Question Remote Database Connection to maintain or not?

Jakes72

Active Member

Erel

B4X founder

Jakes72

Active Member

josejad

Expert

jRDC2 MSSQL getting error fetching connection when connecting

Similar Threads

Android Question Remote Database Connection to maintain or not?

Jakes72

Active Member

Erel

B4X founder

Jakes72

Active Member

josejad

Expert

jRDC2 MSSQL getting error fetching connection when connecting

Similar Threads

Privacy & Transparency

Privacy & Transparency