iOS Question Connect to Azure

Graeme M itchell

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
 

Graeme M itchell

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]
 

Graeme M itchell

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
 

Graeme M itchell

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?
 
Top