My B4j App successfully connected directly on a SQL Server
Is it possible to port B4j JSQL to android to connect directly on a SQL Server or there is an existing library for this. Tnx
B4X:
#Region Project Attributes
#CommandLineArgs:
#MergeLibraries: True
#AdditionalJar: jtds-1.3.1.jar
#End Region
Sub Process_Globals
Dim JSQL As SQL
End Sub
Sub AppStart (Args() As String)
JSQL.Initialize("net.sourceforge.jtds.jdbc.Driver", "jdbc:jtds:sqlserver://192.168.1.244/nino;user=developer;password=developer")
Test
End Sub
Sub Test
Dim RS As ResultSet = JSQL.ExecQuery("SELECT * FROM tbl_employee")
Do While RS.NextRow
Dim m As Map : m.initialize
For x = 0 To RS.ColumnCount -1
m.Put(RS.GetColumnName(x), RS.GetString2(x))
Next
Log(m)
Loop
End Sub
Is it possible to port B4j JSQL to android to connect directly on a SQL Server or there is an existing library for this. Tnx