Android Question Connect to a MSSql Database with B4A/jRDC2

stefanoa

Active Member
Licensed User
Longtime User
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
 
Sort by date Sort by votes

EnriqueGonzalez

Well-Known Member
Licensed User
Longtime User
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
 
Upvote 0
You must log in or register to reply here.

Similar Threads

R
  • Question
Android Question Connecting to 2 MySQL Databases at the same time with JRDC2?
Replies
1
Views
282
Rodrigo Vargas
R
F
  • Question
Android Question Connect to msslql server - sql.bsite.net\mssql2016
Replies
10
Views
1K
aeric
  • Question
Android Question Connect to MS SQL SERVER with SSL, may be using mssql-jdbc-8.4.1.jre11. Posible?
Replies
8
Views
2K
Albert Kallal
L
  • Question
Android Question How to Connect to MS-SQL Server 2016 in B4A
Replies
8
Views
7K
LBor
L
A
  • Question
Android Question I want an example in connecting b4a with mysql online .. Thanks
Replies
6
Views
3K
AlfaizDev
A
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…