marcello Member Licensed User Longtime User Aug 19, 2013 #1 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.
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 B4X founder Staff member Licensed User Longtime User Aug 20, 2013 #2 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 Upvote 0
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 Member Licensed User Longtime User Aug 20, 2013 #3 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 Upvote 0
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 B4X founder Staff member Licensed User Longtime User Aug 21, 2013 #4 The driver is: net.sourceforge.jtds.jdbc.Driver Have you copied the file to the jdbc_driver folder? Are you running Java 7? Upvote 0
The driver is: net.sourceforge.jtds.jdbc.Driver Have you copied the file to the jdbc_driver folder? Are you running Java 7?
marcello Member Licensed User Longtime User Aug 21, 2013 #5 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 Upvote 0
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 B4X founder Staff member Licensed User Longtime User Aug 22, 2013 #6 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. Upvote 0
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.
