Android Question How to connect to microsoft sql server from B4A

[Ramon Bustamante]

Hello,
I'm looking for an example of how to connect to sql server using jdbc.
I have read the post https://www.b4x.com/android/forum/threads/jdbcsql-directly-connect-to-remote-databases.84016/
but it doesn't work because I think it is not for SQL Server.

Thanks

 

[Erel]

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

 

[Ramon Bustamante]

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

Where can I find sample code to do this?

 

[Erel]

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>

 

[swChef]

I just did this today.

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