Android Question JDBC server timeout.

David Elkington

Active Member

Licensed User

Longtime User

• Jan 7, 2017

• #2

Also, I seem to have a ioexception: Connection Refused in the debug window

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jan 8, 2017

• #3

Are you using the old RDC 1? You should use jRDC2: https://www.b4x.com/android/forum/threads/61801/#content

Based on the error, RDC cannot connect to the database. Is the database hosted on the same computer? If not then you should make sure that the firewall allows incoming connection on the SQL Server default port.

 

Upvote 0

David Elkington

Active Member

Licensed User

Longtime User

• Jan 8, 2017

• #4

Hi Erel,

Yes, the SQL Server is on the same machine, it is a VM on a Mac at the moment, but I am buying a PC to run it off. I will try updating to the second version, but I am not sure that will help if I can't get past the stage of connecting to a database. Do you think it could be the JDBC driver? I have downloaded the version from Microsoft and the tdbc shown in your tutorial, however I think the instance may be throwing things off?

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jan 8, 2017

• #5

David Elkington said:

Do you think it could be the JDBC driver?

Click to expand...

No.

What is the ip address of the VM?
Which version of Windows are you using?

 

Upvote 0

David Elkington

Active Member

Licensed User

Longtime User

• Jan 8, 2017

• #6

Hi Erel,

the VM is running on 192.168.0.11 and I am running windows 10 with SQL server 2012.

I have tried to use the MS jdbc driver as below in the config.properties

#SQL Server
DriverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
JdbcUrl=jdbc:sqlserver://localhost/QUINGOCRM:1433;databaseName=riskassessment;user=database;password=database0407;
User=database
Password=database0407
ServerPort=17178

The file in the jdbc_driver directory is now sqljdbc4.jar as opposed to the jets-1.3.1.jar I was using before.

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jan 8, 2017

• #7

Have you disabled Windows Firewall?

 

Upvote 0

David Elkington

Active Member

Licensed User

Longtime User

• Jan 8, 2017

• #8

Yes, I disabled that. If I use the jts driver, should my config file be like this to get to a database on instance QUINGOCRM called riskassessment?

DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://localhost/QUINGOCRM/riskassessment
User=database
Password=database0407
ServerPort=17178

When I do a netstat -a however, I cannot see 1433 as being listened to, I can see a UDP [: :] : 1434 however and I know the SQL server is running as I can connect to another database running on it using MS Access. Most confused.

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jan 8, 2017

• #9

Are you running RDC inside the VM or on the Mac?

 

Upvote 0

David Elkington

Active Member

Licensed User

Longtime User

• Jan 8, 2017

• #10

Im running RDC in the VM, I have attached what my window shows.

 

Upvote 0

David Elkington

Active Member

Licensed User

Longtime User

• Jan 8, 2017

• #11

Seems to say connection refused.

 

Upvote 0

David Elkington

Active Member

Licensed User

Longtime User

• Jan 8, 2017

• #12

That was painful, it was an issue with the SQL Server, the browser service was tied to another instance and the QUINGOCRM instance was not listening on 1433. I uninstalled SQL entirely and reinstalled and now it it is working.

 

Upvote 0