1 Reply Latest reply on Jun 24, 2013 11:51 AM by sushaant

    vb and oracle 10g


      how to connect to oracle 10g using vb 2008 express edition?

        • 1. Re: vb and oracle 10g

          Public connMDBServer As New ADODB.Connection
          Public rsServer As ADODB.Recordset

              connMDBServer = "Provider=MSDASQL;" & _
            "Driver={Microsoft ODBC for Oracle}; " & _
            "CONNECTSTRING=" & strTNS
          connMDBServer.Open , strUserName, strUserPassword

          strSQLQuery="select * from dual"

          rsServer.Open strSQLQuery, connMDBServer, adOpenDynamic, adLockOptimistic

          You need to use DAO Object library from references which should be readily available in all windows machine. also provide tns and user information in above variables. This should work