1 Reply Latest reply: Jun 24, 2013 6:51 AM by sushaant RSS

    vb and oracle 10g

    065e57b7-0448-43d4-85ff-2166cff77d28

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

        • 1. Re: vb and oracle 10g
          sushaant


          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