R Ramon Bustamante Member Licensed User Nov 21, 2017 #1 Hello, I'm looking for an example of how to connect to sql server using jdbc. I have read the post https://www.b4x.com/android/forum/threads/jdbcsql-directly-connect-to-remote-databases.84016/ but it doesn't work because I think it is not for SQL Server. Thanks
Hello, I'm looking for an example of how to connect to sql server using jdbc. I have read the post https://www.b4x.com/android/forum/threads/jdbcsql-directly-connect-to-remote-databases.84016/ but it doesn't work because I think it is not for SQL Server. Thanks
Erel B4X founder Staff member Licensed User Longtime User Nov 21, 2017 #2 You can use JdbcSQL to connect to MS SQL. Use it together with the jdts driver. Upvote 0
R Ramon Bustamante Member Licensed User Nov 21, 2017 #3 Erel said: You can use JdbcSQL to connect to MS SQL. Use it together with the jdts driver. Click to expand... Where can I find sample code to do this? Upvote 0
Erel said: You can use JdbcSQL to connect to MS SQL. Use it together with the jdts driver. Click to expand... Where can I find sample code to do this?
Erel B4X founder Staff member Licensed User Longtime User Nov 21, 2017 #4 Start with this tutorial: https://www.b4x.com/android/forum/threads/sql-tutorial.35185/#content You need to find three parameters: #AdditionalJar, jdbc driver class and the connection string. jar name: jtds-1.2.8 (or similar) driver: net.sourceforge.jtds.jdbc.Driver connection string: jdbc:jtds:sqlserver://<server address>/<database> Upvote 0
Start with this tutorial: https://www.b4x.com/android/forum/threads/sql-tutorial.35185/#content You need to find three parameters: #AdditionalJar, jdbc driver class and the connection string. jar name: jtds-1.2.8 (or similar) driver: net.sourceforge.jtds.jdbc.Driver connection string: jdbc:jtds:sqlserver://<server address>/<database>
swChef Active Member Licensed User Longtime User Nov 22, 2017 #5 I just did this today. https://sourceforge.net/projects/jtds/files/jtds/1.3.1/ Upvote 0
