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’