Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    3

    Red face Unanswered: Oracle Integration with VB.Net

    Hi!

    when I executed this query (select table_name from tabs) through VB.NET, part of the output data was shown as pipes "|||" and the rest was shown correctly, here is part of the code segment in VB.net

    so, any clue what might help,
    thanks


    Dim oradb As String = "Data Source=OPERA;User Id=vendome;Password=vendome;"

    Dim conn As New OracleConnection(oradb)

    Try
    conn.Open()
    Dim cmd As New OracleCommand()

    cmd.CommandText = "select table_name from tabs"
    cmd.Connection = conn
    cmd.CommandType = CommandType.Text

    Dim rd As OracleDataReader = cmd.ExecuteReader
    While (rd.Read)
    CMB.Items.Add(rd.GetValue(0))
    End While

    Catch ex As Exception ' catches any error
    MessageBox.Show(ex.Message.ToString())
    Finally
    conn.Dispose()
    End Try

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    So, when you execute this query from SQL*plus (or the sql client you're using), what is the output you get ?

  3. #3
    Join Date
    May 2006
    Posts
    3
    the output is correct when I execute it throught sql client.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •