OLE DB SDK 2.1 ---- MDAC 2.1

[VBQuery]

Hi guys
I am getting some oracle database connection problems when using ADODB. Actually,Oracle OLE DB Provider needs
1) OLE DB SDK 2.1
2) MDAC 2.1

How do I check if I have them or not in my system .
If not Where can i download them from.

The code that is giving problem is :

Dim adCon As New ADODB.Connection, str As String
Private Sub Form_Load()
strCon = "Provider=OraOLEDB.Oracle;DataSource=_server_name User ID=_user_id;Password=_pwd_;"
adCon.Open strCon
End Sub

I am totally new to VB

Is that the correct provider name to be able to connect to Oracle ? or should I use MSDAORA

And also in setting up System DSN .....
there are 2 drivers in system dsn - Microsoft ODBC for Oracle and Oracle ODBC driver
Which One to use ?

It will be really great if some one can help me outtttt..

Thanks in adv.

 

[Terpsfan]

Actually you want to use the Microsoft OLEDB Provider for Oracle. It should be one of your connection options when you are building a connection string. If you just place an ADO data control on your form and right click it, you'll get your connection options.

http://www.microsoft.com/data/download.htm

for the latest version of MDAC, which I believe is now 2.6. You can view what version of MDAC you have within Visual Basic by going to Projects---References.