P Pisinho Active Member Licensed User Longtime User Apr 16, 2014 #1 I read a tutorial RDC with SQL but i don't understanding. I have a SQL server in my private lan and i have a linux server with IP static for mail and web server (Apache). I would use a RDC for application which send query when a person with tablet or phone are out of office. What steps should I do to get this ? you have a source example for MSSQL ? Thanks in advance.
I read a tutorial RDC with SQL but i don't understanding. I have a SQL server in my private lan and i have a linux server with IP static for mail and web server (Apache). I would use a RDC for application which send query when a person with tablet or phone are out of office. What steps should I do to get this ? you have a source example for MSSQL ? Thanks in advance.
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
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.
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 Code: #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: serveraddress:1089/?method=test serveraddress:1089/?databasename Any help will be appreciated. Upvote 0
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 Code: #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: serveraddress:1089/?method=test serveraddress:1089/?databasename Any help will be appreciated.
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 Code: Error: java.net.SocketTimeoutException Somewhere in the logs () from the command prompt, I noticed this line too: Code: 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
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 Code: Error: java.net.SocketTimeoutException Somewhere in the logs () from the command prompt, I noticed this line too: Code: 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()
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
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.
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
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)
