I am running a simple SELECT statement in VB using ADODB something like this:
Dim DBCmd as New ADODB.Command
DBCmd.Execute "SELECT * FROM USER_DATA WHERE PERSON_ID = '" & PersonID & "'"
Set PersonRS = DBCmd.Execute
This query works fine. I am told that the data is actually housed in another Oracle database instance, and I need to do a "COMMIT" after the select. How do I do this?