Android Question How to connect to MSSQL with JdbcSQL

catyinwong

Active Member
Licensed User
Longtime User
Not quite understand what changes should be made if I want to connect to a MSSQL
#AdditionalJar: jtds-1.3.1

Public mysql As JdbcSQL
Private driver As String = "com.mysql.jdbc.Driver" <- what to change??
Private jdbcUrl As String = "jdbc:mssql://192.168.0.6/test"
Private Username As String = "username"
Private Password As String = "password"
 

Erel

B4X founder
Staff member
Licensed User
Longtime User
The driver should be: net.sourceforge.jtds.jdbc.Driver

JdbcUrl is explained here: http://jtds.sourceforge.net/faq.html#driverImplementation
Try: jdbc:jtds:sqlserver://192.168.0.6/test

I recommend you to start with B4J jSQL and connect to jdbc:jtds:sqlserver://127.0.0.1/test

Once it works switch to the B4A program.
 
Upvote 0
Top