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}; " & _
      "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

Legend

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