Android Question Android JSQL

[BarryW]

My B4j App successfully connected directly on a SQL Server

#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

 

[DonManfred]

Wrong forum! This is the B4A forum...
I´ll let the Thread move to B4J Forum...

 

[ilan]

Wrong forum! This is the B4A forum...
I´ll let the Thread move to B4J Forum...

He is asking how to convert his b4j app to b4a so i think this is the correct forum.

@BarryW just try the same code, should work also on b4a

 

[BarryW]

Tnx...

 

[Erel]

You can try it. Whether it will work or not depends on whether the jtds driver is compatible with Android or not.

As a general rule it is a mistake to connect directly to the database. Especially if this is a consumer app.

Use jRDC2 instead.

 

[ilan]

Use jRDC2 instead.

Or php (just kidding, please dont ban me)

The limitations with jrdc2 is that it doesnot work on shared hosting. And i think most people here have their db's on shared hosts.

 

[BarryW]

Let say jRDC2 is compatible but how can i access it? Using SQL Lib? Which having different parameter of connection...

 

[Erel]

You need to learn how to work with RDC. It is quite simple.

Start with this tutorial: https://www.b4x.com/android/forum/threads/31616/#content

 

[BarryW]

i know how to use RDC but i want connect directly on my MS SQL Server without third party software... Tnx...

 

[b4auser1]

MSSQL with JDBC Library v1.0
try this to access ms sql directly from android

 

[BarryW]

it doesnt work for me... Anyway thx...