Android Question Connect to a MSSql Database with B4A/jRDC2

[stefanoa]

I followed the installation note from the article in this post

My questions:
1) For MsSql connection i have to use #AdditionalJar: jtds-1.3.1.jar in Main?
2) How to run a B4J server on a Windows server?
Some examples?
Thanks

 

[EnriqueGonzalez]

hi you could begin here:

config.properties - MS Sql driver for JDBC

I am trying to change the tutorial code for mysql to MS Sql, but I have it wrong. This is my code: DriverClass=com.Drivermicrosoft.sqlserver.jdbc.SQLServerDriver JdbcUrl=jdbc:sqlserver://localhost/test?characterEncoding=utf8 I could not find the correct connection string elsewhere on the...

www.b4x.com

dont use jtds use sql server official driver:

Download - JDBC Driver for SQL Server

Download the Microsoft JDBC Driver for SQL Server to develop Java applications that connect to SQL Server and Azure SQL Database.

docs.microsoft.com

 

[Erel]

How to run a B4J server on a Windows server?

Start with running jRDC2 from the B4J IDE. Make sure to open the server port in Windows firewall.