Android Question How to connect to MSSQL with JdbcSQL


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://"
Private Username As String = "username"
Private Password As String = "password"


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

JdbcUrl is explained here:
Try: jdbc:jtds:sqlserver://

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

Once it works switch to the B4A program.
Upvote 0