B4J Question Connect B4J to SQL Server Database

See this tutorial: https://www.b4x.com/android/forum/threads/sql-tutorial.35185/#content

Erel said:

See this tutorial: https://www.b4x.com/android/forum/threads/sql-tutorial.35185/#content

Click to expand...

Thanks Erel I will check this out.

Hi Erel I went through that link however is there anything around connecting to a remote SQL Server? Or can I use the code below from that thread and replace the localhost with the external IP address of the SQL server?

#Region Project Attributes#MainFormWidth: 600#MainFormHeight: 400#AdditionalJar: jtds-1.3.1.jar#End RegionSub Process_GlobalsPrivate sql1 AsSQLEnd SubSub AppStart (Form1 AsForm, Args() AsString)Try
sql1.Initialize("net.sourceforge.jtds.jdbc.Driver","jdbc:jtds:sqlserver://localhost:1433/NombreBD;user=xxx;password=yyy")CatchLog("Error de conexión con la BD "EndTry
End Sub

Please use [code]code here...[/code] tags when posting code.

Adrian Trantino said:

Or can I use the code below from that thread and replace the localhost with the external IP address of the SQL server?

Click to expand...

Yes.

A better solution is to use InitializeAsync for remote databases.
And the best solution is to use ConnectionPool from jServer library.

Erel said:

Please use [code]code here...[/code] tags when posting code.


Yes.

A better solution is to use InitializeAsync for remote databases.
And the best solution is to use ConnectionPool from jServer library.

Click to expand...

Thanks Erel basically I'm trying to populate a table in my form with data from my remote SQL Server database. Is there any advice you have for this type of project?
I don't need to upload/post data back into the database only read from it.

Start with the standard SQL commands. Once you get it working, switch to the asynchronous methods.