Thursday 7 April 2016

Connecting to Oracle 11G from VB 6

The steps are the same as to connect to Oracle 10G, except for one matter - we have to set the current schema before running any queries through - ALTER SESSION SET CURRENT_SCHEMA=<SCHEMA_NAME>