Android Question RDC with Ms SQL server example or howto

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Apr 16, 2014

• #2

You can access MS SQL with jtds driver. See the commented configuration here: http://www.b4x.com/android/forum/threads/remote-database-connector-connect-to-any-remote-db.31540/

RDC is a web server. It can work in both the local network and the internet.

 

Upvote 0

Kwame Twum

Active Member

Licensed User

Longtime User

• Sep 18, 2014

• #3

Hi Erel, I'm connecting to a remote MS SQL and can't seem to access the remote server from the browser. These are my configurations:

• From the config file

B4X:

#SQL Server
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://serveraddress/databasename
User=myuser
Password=mypass
ServerPort=1089

• Image of running RDC server

I'm not too sure how to access it via a browser...
I've tried the following but to no avail:

1. serveraddress:1089/?method=test
   
2. serveraddress:1089/?databasename

Any help will be appreciated.

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Sep 19, 2014

• #4

Start with 127.0.0.1:1089?method=test in the local browser.

 

Upvote 0

Kwame Twum

Active Member

Licensed User

Longtime User

• Sep 20, 2014

• #5

Thanks Erel, it worked, I however received:

RemoteServer is running (Sat Sep 20 10:41:39 BST 2014)
java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.

always timing out... any suggestions?

And when I send a request with the client device, I get

B4X:

Error: java.net.SocketTimeoutException

Somewhere in the logs () from the command prompt, I noticed this line too:

B4X:

Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@47baec4c -- timeout at awaitAvailable()

 

Last edited: Sep 20, 2014

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Sep 21, 2014

• #6

The first error means that RDC failed to connect to the database server. You should check the database server configuration and make sure that the user name and password are correct and that it allows remote connections.

 

Upvote 0

Kwame Twum

Active Member

Licensed User

Longtime User

• Sep 21, 2014

• #7

Erel said:

You should check the database server configuration and make sure that the user name and password are correct and that it allows remote connections.

Click to expand...

So far, so good... credentials are accurate. And it does allow remote connections... (I work on it from my Mgt. Studio everyday with those same credentials)

 

Upvote 0