ADODB connection

[michaelX]

I mainly use MySQL, SAPDB and Oracle databases - and so far have found that using the ADODB connection to open and work with these databases is extremely fast compared to other methods available in dot net anyone else found this so.

    Public conn As ADODB.Connection
    Public subrs As ADODB.Recordset
    Public rs As ADODB.Recordset
    Public sapconn As ADODB.Connection
    Public sapsubrs As ADODB.Recordset
    Public saprs As ADODB.Recordset


        Try
            conn = New ADODB.Connection
            rs = New ADODB.Recordset
            subrs = New ADODB.Recordset

            conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
               & "SERVER=localhost;" _
               & "DATABASE=<databasename>;" _
               & "UID=root;" _
               & "PWD=<password>;"
            conn.Open()

        Catch ex As System.Exception
            MsgBox(ex.Message)
        End Try



        Try
            sapconn = New ADODB.Connection
            saprs = New ADODB.Recordset
            sapsubrs = New ADODB.Recordset
            sapconn.ConnectionString = "DRIVER={MaxDB};" _
                                            & "SERVER=<servername>;" _
                                            & "DATABASE=<databasename>;" _
                                            & "UID=<username>;" _
                                            & "PWD=<password>;"
            sapconn.Open()
        Catch ex As System.Exception
            MsgBox(ex.Message)
        End Try

 

[cjard]

I use Oracle. I recently had a need to bulk load data into oracle at high speed. The best performance I got out of it, including a trigger that performed something in the region of 100 string replacements per record, was about 350,000 records per minute, and the technology in use was ODP.NET (oracle's .net library)
performance of MS' library was around 100,000 records per minute

 

[subcode]

i try to use this method because this is the one i use in vb6. but when i retrieve data there is an underlined error. i.e RS!ColumnName

 

[cjard]

i try to use this method because this is the one i use in vb6

A couple of things have happened since the 1980s

Start with the DW2 link in my signature, section Creating a Simple Data App

 

[subcode]

tnx sir cjard. i'll try