HI Guys,
I've gone through the forum to find piece of code to connect to oracle. i believe my connection string is correct:

Dim strCon
strCon = "Driver={Microsoft ODBC for Oracle}; " & _
"(HOST=MYHOST)(PORT=1555))" & _
"(CONNECT_DATA=(SID=D1D2))); uid=myuserid;pwd=passw0rd;"

Dim oCon
Set oCon = CreateObject("ADODB.Connection")
Dim oRs
Set oRs = CreateObject("ADODB.Recordset")
oCon.Open strCon
Set oRs = oCon.Execute("SELECT myfield FROM mytable")
While Not oRs.EOF
msgbox oRs.Fields(0).Value
Set oRs = Nothing
Set oCon = Nothing

<font color="blue">

Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3(or greater) client software installation.

You will be unable to use this driver until these components have been installed


Any body experienced this? any suggestions plz