I am attempting to move from VB 6 to Vb Net using Oracle as the database. I cannot figure out the proper connection and/or access methods needed to retrieve the rows of data from the Oracle tables. I have attached a wordpad text document showing the VB 6 code that seems to work but does not return the desired data, and raises an error condition.

Is there any one that can tell me what the changes are that need to be made to make these functions work properly?

I'm a new member and not sure the attachment worked.


I had modified some of the codings and attached the file with this. Check it and send me the feedback.

best regards,