SHOLA KUKU Member Licensed User Oct 8, 2019 #1 Greetings, Am having difficulty connecting to my local MSSQL Server and database using this connection string: sql1.InitializeAsync("sql1","net.sourceforge.jtds.jdbc.Driver","jdbc:jtds:sqlserver://192.168.8.101:1433/PDATA;instance=scaexpress;loginTimeout=10000;","user","userpwd") Notes: 1. //192.168.8.101 - My PC IP address 2. 1433 - SQL Server port number 3. PDATA - my database 4. scaexpress - SQL Server instance Any help? Thanks in advance.
Greetings, Am having difficulty connecting to my local MSSQL Server and database using this connection string: sql1.InitializeAsync("sql1","net.sourceforge.jtds.jdbc.Driver","jdbc:jtds:sqlserver://192.168.8.101:1433/PDATA;instance=scaexpress;loginTimeout=10000;","user","userpwd") Notes: 1. //192.168.8.101 - My PC IP address 2. 1433 - SQL Server port number 3. PDATA - my database 4. scaexpress - SQL Server instance Any help? Thanks in advance.
EnriqueGonzalez Well-Known Member Licensed User Longtime User Oct 8, 2019 #2 JTDS is outdated. you should use the official microsoft library according to this page you should download: https://docs.microsoft.com/en-us/sq...ents-for-the-jdbc-driver?view=sql-server-2017 mssql-jdbc-6.4.0.jre7.jar this is because you need a JRE7 version. Apart from it. i do not recommend in anyway connecting directly to the database, security issues apart, it is very unstable. you will desist within a week of trying. Upvote 0
JTDS is outdated. you should use the official microsoft library according to this page you should download: https://docs.microsoft.com/en-us/sq...ents-for-the-jdbc-driver?view=sql-server-2017 mssql-jdbc-6.4.0.jre7.jar this is because you need a JRE7 version. Apart from it. i do not recommend in anyway connecting directly to the database, security issues apart, it is very unstable. you will desist within a week of trying.
OliverA Expert Licensed User Longtime User Oct 9, 2019 #3 I don’t think any microsoft JDBC drivers work with Android. So JTDS may be it. I’ve gotten it to work with up to sql server 2016. https://www.b4x.com/android/forum/threads/mssql-jdbc-minimalistic-example.90548/#post-573443 Upvote 0
I don’t think any microsoft JDBC drivers work with Android. So JTDS may be it. I’ve gotten it to work with up to sql server 2016. https://www.b4x.com/android/forum/threads/mssql-jdbc-minimalistic-example.90548/#post-573443
OliverA Expert Licensed User Longtime User Oct 9, 2019 #4 SHOLA KUKU said: Any help? Click to expand... Any log messages that may help us determine what is going on? Upvote 0
SHOLA KUKU said: Any help? Click to expand... Any log messages that may help us determine what is going on?