November 23rd, 2003, 05:46 PM
Connecting Visual Basic to Oracle
Can someone please provide me detailed instructions on how I can connect Visual Basic 6.0 Professional to Oracle 8.1.5 (which is on a server) using the Oracle Driver (not Microsoft ODBC Driver)?
Do I need a DSN and TSN?
What is the VB code that I use and where would I place it in my VB Project?
What references/libraries do I need--how would I add them to the project?
How can I send a SQL queries and retrieve results from the Oracle server?
As you can tell, this is my first time doing this...please help. I would greatly appreciate it. Thanks.
November 24th, 2003, 05:05 AM
In order to use Oracle's ODBC driver you have to install Oracle Client and configure your tnsnames.ora.