Please help. i am using vb.net 2005 express edition. i dont know what is wrong with my code below. I am trying to retrieve a table from our Oracle database(8i) but when it passes to da.Fill(ds, "tableName") exception is thrown
error says: "table or view does not exist"
i tried to query the below command to TOAD, and the table exists with records on it.
Dim myCon As String = "Data Source=MSDAORA.1;User ID=scott;password=tiger;Data Source=PHDB;Persist Security Info=False"
Dim ds As DataSet
Dim cn As OracleConnection
cn = New OracleConnection(myCon)
Dim da As New OracleDataAdapter
da.selectcommand = New OracleCommand("select itemno, pono, slilotno, quantity, expirationday from inboxtbl where orderno= '277503'", cn)
ds = New DataSet("ds")
da.Fill(ds, "inboxtbl")//same error on da.Fill(ds)
any workaround on this will be much appreciated.
thank you in advance.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic