This discussion is archived
1 Reply Latest reply: Jun 24, 2013 4:51 AM by sushaant RSS

vb and oracle 10g

065e57b7-0448-43d4-85ff-2166cff77d28 Newbie
Currently Being Moderated

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

  • 1. Re: vb and oracle 10g
    sushaant Newbie
    Currently Being Moderated

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

        connMDBServer = "Provider=MSDASQL;" & _
      "Driver={Microsoft ODBC for Oracle}; " & _
    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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points