C catyinwong Active Member Licensed User Longtime User Jul 23, 2018 #1 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"
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 Jul 23, 2018 #2 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
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.
