Visual Basic connection to Oracle

Hi,

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.

U can find some knowledge and tutorial about how to use oracle DB..Or send message to Fisherman who is a master on DB program in this forum!

Thanks for the vote of confidence, CP.. I'll try to help here.

Ok.. here's the deal guys. VBO - you'll need to do one of the following things. You'll either need to gain access to the Oracle 8i client installation disks, or you'll need to visit here and sign up for a free Oracle Technology Networks account (you get a free quarterly magazine about SQL if nothing else). After you do that, you'll need to go to This site and download the provider required for your installation of Oracle. NOTE: You don't need to do both - just one or the other. The Oracle client installation has the provider included on every version since 7.33. If you can't gain access to the CD's, then go to the site. You'll need the OTN sign-in to download the file. Once you have that, and have installed the provider, then I would go to project->components, and add Microsoft ADO Data Control. Use the connection string property in the properties box to build a connection string using the Oracle OLEDB provider, and then post that connection string into your connection string for your connection object in VB. Good Luck!

upon further inspection. I have tried to connect to one of the Oracle DB's here in our facility, and am having some trouble setting up the DSN. I will continue working on this, and will aprise you when I have figured it out.

well, guys. I must admit that I'm sorry (and after all that praise from CP ). the problem is that we're a SQLServer shop here, and we only have two oracle boxes. I've tried gaining access to them, but to no avail. Basically, the process would involve the following, though

1. Getting the Oracle client provider as designated by the oracle version number and described in my earlier post.

2. Using the Oracle Net Administrator to set up the appropriate links to your database.

3. Going to the ODBC manager and adding a DSN to the database using the Oracle driver (try not to use the MS for Oracle OLEDB driver).

4. Use the connection and recordset objects as normal.

I know that my small voice will never be heard by the big wigs at "X" corporation... but guys - this is nuts. ODBC is supposed to be a standard for allowing developers to connect to any database on any platform. Instead what we have is that I can't create a DSN to an Oracle DB unless I download Oracle specific software? How is this any better that MS domination? Why don't you stick to the basics and follow the standard. But then again... that's only my opinion.