Android Question Remote Database Connector to Microsoft SQL Server

[marcello]

I have to connect the android app with a Microsoft SQL Server (express) with RDC but the tutorial on line is't unclear. I have problems with the configuration file and the jdbc driver.

 

[Erel]

Did you got any error? Which step was not clear?

You should download JTDS driver: http://jtds.sourceforge.net/ and copy jtds-1.3.1.jar to the jdbc_driver folder.
Note that jtds requires Java 7.

You can see several examples of connections strings here (JdbcUrl in config.properties):
http://stackoverflow.com/questions/1862283/help-me-create-a-jtds-connection-string

 

[marcello]

I've a new problem : in configuration file i have write the JdbcUrl same this string
JdbcUrl=jdbc:jtds:sqlserver://127.0.0.1:1433/anagrafica;instance=SQLEXPRESS

but the DriverClass not it's not rigth :
DriverClass=net.sourceforge.jtds.jdbc.Driver

can you send me aexample of file configuration for Microsoft SQL Server ?
I send you the display error when i strat the http://127.0.0.1:17178/?method=test

 

[Erel]

The driver is: net.sourceforge.jtds.jdbc.Driver


Have you copied the file to the jdbc_driver folder? Are you running Java 7?

 

[marcello]

Yes, have to,

Now I've new problem : the connection has timed out

the my file configuration is

......
#SQL Server
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://127.0.0.1:1433/Facture;instance=SQLEXPRESS
#User=root
#Password=
ServerPort=17178
#If Debug is true then this file will be reloaded on every #query.
#This is useful if you need to modify the queries.
Debug=true
......

Facture is my database

 

[Erel]

This is a different issue. Most probably related to your SQL Server configuration. You should open it to remote connections and create a user account for that connection.