none
Connecting to oracle on 64 bit machine with 32 bit client in vb.net RRS feed

  • General discussion

  • I need to have a 32 bit oracle client installed my test PC which is acctually a 64 bit machine.when i try connecting to oracle in my window application in vb.net ,it does not open the connection.

    Imports

     

    Oracle.DataAccess.Client

    Public

     

    Class Form1

     

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

     

    Dim oradb As String = "Data Source=DEV;User Id=XX_CUSTOM;Password=XXCUSTOM;"

     

    Dim conn As New OracleConnection(oradb)

     

    Dim rslocal As New DataSet

     

    Dim adp As New OracleDataAdapter("select distinct basicmaterial from powl_material_def ", conn)

    CatList.Items.Clear()

    conn.Open()

    adp.Fill(rslocal,

    "Oracle")

    conn.Close()

     

    For i As Integer = 0 To rslocal.Tables(0).Rows.Count - 1

    CatList.Items.Add(rslocal.Tables(0).Rows(i)(0).ToString)

     

    Next

     

    End Sub
    can any body help
    thanks
    tina

    • Changed type Martin Xie - MSFT Wednesday, May 6, 2009 9:50 AM Redirect to appropriate forums for better responses.
    • Moved by Esther FanMicrosoft employee Thursday, October 7, 2010 10:32 PM (From:Visual Studio Class Designer)
    Thursday, April 30, 2009 2:47 PM

All replies