SQL table accessing

[Sanjukta]

i am working on a VB project with oracle in the background.i can't seem
to be able to access values from the table thru VB but insertion or
deletion of the SQL table works fine.For eg. the code

Adodc1.RecordSource = "select path from book_info;"
Adodc1.Refresh
e=Adodc1.RecordSource
list1.additem e

shows the text select path from book_info in the listbox & not the
actual path which is stored in the table.my ODBC connection works fine
..can u suggest a different code?

 

[Brendan Reynolds]

Access forms don't use the ADODC control, so microsoft.public.vb.database or
microsoft.public.vb.database.ado might be better newsgroups in which to ask
this question.