B4J Question How do I connect to SQL Server using OLE DB

npsonic · Sep 20, 2017

The title says it all. I have trying to find ways to connect SQL server using OLE DB. It seems that there isn't many ways to achieve this kind of connection.
There is JACOB, but it seems kind of complicated and I'm not sure how to use it in B4J.

Any help is appreciated.

OliverA · Sep 20, 2017

Which SQL Server? MSSQL? PostgreSQL? etc...

npsonic · Sep 21, 2017

OliverA said:
Which SQL Server? MSSQL? PostgreSQL? etc...

MSSQL

Other possibility would be to use some other language like C++ or C# to create app that creates connection to the SQL server.
Then use B4J to control this other app.

OliverA · Sep 21, 2017

npsonic said:
Other possibility would be to use some other language like C++ or C# to create app that creates connection to the SQL server.

Why not use B4J's jSQL and the jTDS JDBC driver?

npsonic · Sep 21, 2017

OliverA said:
Why not use B4J's jSQL and the jTDS JDBC driver?

I have connection string that contains Provider, Data source name and Data source.

Example: Provider=<Some Provider>;Catalog=<Name of the data source>;Data Source=<Some data source>

I would want to create connection using this kind of string. Is it possible by using B4J's jSQL?

OliverA · Sep 21, 2017

Looking at these sources:
https://docs.microsoft.com/en-us/sq...ta-source-sql-server-import-and-export-wizard
https://docs.microsoft.com/en-us/sq...nd-connection-strings-report-builder-and-ssrs

Provider = JDBC/JTDS
Data Source = IP Address/Hostname + Port Number of MSSQL Server
Catalog = database name

Then yes, all doable.

Examples of URL setup (from this post at stackoverflow):

So, to connect to a database called "Blog" hosted by a MS SQL Server running on MYPC, you may end up with something like this:

jdbc:jtds:sqlserver://MYPC:1433/Blog;instance=SQLEXPRESS;user=sa;password=s3cr3t

EnriqueGonzalez · Sep 21, 2017

jtds is for old databases (2008 and below) i suggest to use the Microsoft official libraries for this endeavor, setting up a connection is quite easy actually.

All you need to know is here:
https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server

miker2069 · Sep 23, 2017

To connect to MS SQL Server I use something like...

B4X:

#Region Project Attributes
    #MainFormWidth: 600
    #MainFormHeight: 400
    #AdditionalJar: sqljdbc42.jar
#End Region

Sub Process_Globals
    Private fx As JFX
    Private MainForm As Form
    Private sql1 As SQL
End Sub

Sub AppStart (Form1 As Form, Args() As String)
    MainForm = Form1
    'MainForm.RootPane.LoadLayout("Layout1") 'Load the layout file.
    Dim url As String
    Dim mariadb_url As String
  
    url = "jdbc:sqlserver://LENOVO\SQLEXPRESS;database=NORTHWND;user=sa;password=secretpassword"
    sql1.Initialize("com.microsoft.sqlserver.jdbc.SQLServerDriver",url)
  
  
End Sub

B4J Question How do I connect to SQL Server using OLE DB

npsonic

Active Member

OliverA

Expert

npsonic

Active Member

OliverA

Expert

npsonic

Active Member

OliverA

Expert

EnriqueGonzalez

Well-Known Member

miker2069

Active Member

Similar Threads

B4J Question How do I connect to SQL Server using OLE DB

Active Member

Expert

Active Member

Expert

Active Member

Expert

Well-Known Member

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency