Android Question How to connect to microsoft sql server from B4A

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Nov 21, 2017

• #2

You can use JdbcSQL to connect to MS SQL. Use it together with the jdts driver.

 

Upvote 0

R

Ramon Bustamante

Member

Licensed User

• Nov 21, 2017

• #3

Erel said:

You can use JdbcSQL to connect to MS SQL. Use it together with the jdts driver.

Click to expand...

Where can I find sample code to do this?

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Nov 21, 2017

• #4

Start with this tutorial: https://www.b4x.com/android/forum/threads/sql-tutorial.35185/#content

You need to find three parameters: #AdditionalJar, jdbc driver class and the connection string.
jar name: jtds-1.2.8 (or similar)
driver: net.sourceforge.jtds.jdbc.Driver
connection string: jdbc:jtds:sqlserver://<server address>/<database>

 

Upvote 0

swChef

Active Member

Licensed User

Longtime User

• Nov 22, 2017

• #5

I just did this today.

https://sourceforge.net/projects/jtds/files/jtds/1.3.1/

 

Upvote 0