Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

table or view does not exist OracleDataAdapter.Fill(Dataset)

Aug 22, 2007 11:22PM PDT

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.

Discussion is locked