Clever Geek Handbook

VB and Oracle communication

What are the steps to connect to Oracle 9i with VB6? How can I use modules and stored procedures in VB6 and how can I call SP?

What is the use of ADO that is useful for inserting, updating, finding and removing items from the interface?

+1


source to share


3 answers


You will need ADO to connect to Oracle (add a link to Microsoft ActiveX Data Objects Library).

Need to know where is the Oracle instance hosted along with the username and password?

The connection string for Oracle can be found at www.connectionstrings.com



ADODB.Connection is the one you will need to install.
The connection has an Execute method that you can use for any insert / update / delete statements.

Now read the documentation for the ADO Object Library from MSDN. And, write the code yourself.

+4


source


You can choose between the Oracle OLEDB driver (which I think comes with the Oracle client installation mentioned by YogoZuno) or from Microsoft (can't remember if it was the standard microsoft oledb driver or was released with a nod towards oracle): driver anyway Oracle OLEDB is much better.



+1


source


You will also need to install the Oracle client on your computer along with the appropriate TNS name file. Also, keep in mind that there are some minor functional differences between different versions of the Oracle 9 client - I had some issues in v9.2.0.1 that weren't seen in v9.2.0.7.

0


source






More articles:


All Articles