Android Question How to connect to MSSQL with JdbcSQL

Discussion in 'Android Questions' started by catyinwong, Jul 23, 2018.

  1. catyinwong

    catyinwong Active Member Licensed 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"
     
  2. Erel

    Erel Administrator Staff Member Licensed 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.
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice