locked
Oracle connection problem in VB.Net at windows 7 32bit OS Machine RRS feed

  • Question

  • Hi,

    My desktop application is developed using vb.net in Framework 4.0 and the same is working on windows XP machine without any issue.

    Issue is, When i run the same application on windows 7 32bit machine connection is not opening instead it throws an error with empty message.

    Oracle 32bit client is installed in both machines.

    Please advise me to resolve the error.

    The below code is used for development.

    Dim con As New OracleConnection

    Dim cmd As OracleCommand

    Dim cda As New OracleDataAdapter

    Dim sqltext As String = "select folio_no from investor_master where tax_no = '" & TextBox1.Text & "' And rownum=1 "

    con = New OracleConnection("user id=ittmf; password=xyz#0000;data source=dotnetnew")

    cmd = New OracleCommand(sqltext, con)

    cmd.CommandType = Data.CommandType.Text

    con.Open()

    Dim FOLIO_NO As String = ""

    FOLIO_NO = cmd.ExecuteScalar()

    Thanks in advance.

    Regards,

    Magesh.D

    Wednesday, March 26, 2014 11:36 AM