Android Question Am having difficulty connecting to my local MSSQL Server

SHOLA KUKU

Member
Licensed User
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.
 

Enrique Gonzalez R

Well-Known Member
Licensed User
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
Top