ADODB.connection

Question:
I use ADO with an Oracle database. To get the connection I have to use:

 dim Adodb as New ADODB.connectionwith Adodb     .connectionString = ????     .openend with

What do I fill in for the Adodb.connectionString?

Answer:
The ConnectionString property is a concatenation of several properties. A typical ConnectionString for Oracle would be 'Provider=MSDAORA.1;Data Source=local;Persist Security Info=False'. You can set the Provider property separately to ‘MSDAORA.1’

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: