Best method to connect Oracle from VB

vijayma · January 21st, 2005, 03:06 AM

All,

anybody post me which is the best & fastest method to connect oracle from visual basic, i am using Ole provider MSDAORA,but in this the processing is taking in the ratio of 2:1 i.e 2 parsing and 1 execution in the backend.

BrianWren · January 28th, 2005, 06:04 PM

This is currently called âthe bestâ:

Code:

    c.Provider = "MSDAORA.1"              ' OLE-DB Provider for Oracle.
    c.ConnectionString = "Data Source=DIS;" & _
                         "User ID=" & UserNm & ";" & _
                         "Password=" & pw & ";" & _
                         "Persist Security Info=False"

What makes you say âprocessing is taking in the ratio of 2:1. i.e., 2 parsing and 1 execution in the backend?â