iOS Question Connect to Azure

G

Graeme Mitchell

Member
Licensed User
Hi, have searched to see if b4i can connect to Azure. I have downloaded sqljdbc_6.0 and I know I read somewhere I am supposed to put the sqljdbc42.jar file in th
 
Sort by date Sort by votes
G

Graeme Mitchell

Member
Licensed User
I have looked for hours through ever post and I am just not getting how to you use JSON/HTTPJOB to connect to AZURE

What I currently use in VB.NET is as follows (can someone translate for B4I?)

B4X: 
    Public Function Load_Data_Grid(ByRef Grid As DataGridView, ByRef table As String, ByRef filter As String)
        Dim myconnection As String
        Dim strSQL As String

        myconnection = "server=***********************;uid=********;pwd=r*******5;database=dbo.TCIC"
        Dim connection As New SqlConnection(myconnection)
        strSQL = "SELECT * FROM " & table
        Dim dataadapter As New SqlDataAdapter(strSQL, connection)
        Dim ds As New DataSet()
        connection.Open()
        dataadapter.Fill(ds, "QC_Data")
        Dim dv As DataView = New DataView(ds.Tables("QC_Data"))
        dv.RowFilter = "Machine = " & filter
        dv.Sort = "Id Asc"
        connection.Close()
        Grid.DataSource = dv
        If Grid.RowCount > 0 Then
            Grid.FirstDisplayedScrollingRowIndex = Grid.RowCount - 1
        End If
    End Function
[\code]
 
Upvote 0
G

Graeme Mitchell

Member
Licensed User
This is the Visual Basic code that I use, however, I am not sure how I would translate this into B4I and use the REST API. I guess I am looking for some guidance on how to do this. Please keep in mind I am new user to B4I
 
Upvote 0
G

Graeme Mitchell

Member
Licensed User
Firstly, thank you for being patient and answering my questions. I have found some connection strings but I am not sure if they would apply for B4I.

The connection strings are either ADO.NET, JDBC, ODBC or PHP. Could I use any of these with iHttpUtils2 and the httpjob?
 
Upvote 0
You must log in or register to reply here.
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…