Hello All,

  Happy New Year!

I am new to microsoft ODBC and I have tried many, many days and failed on connecting to Oracle 11g through my microsoft ODBC.

I am not sure on what I did wrong so I would like to seek your helps and your expertise.

1) I configured my Oracle ODBC driver configuration on my window machine and I was able to connect to the Oracle 11g. Test connection was successful.

2) I was also able to connect to oracle through C:\Windows\SysWOW64\odbcad32.exe

2) However, I was having a problem when I tried to connect to oracle 11g through Microsoft ODBC for Oracle driver through my connection string . It said that Microsoft ODBC Driver was not defined or specified.

con = CreateObject ("ADODB.Connection")

strCon = "Driver={Microsoft ODBC for Oracle}; " & _

                            "CONNECTSTRING=(DESCRIPTION=" & _

                             "(ADDRESS=(PROTOCOL=TCP)" & _

                             "(HOST=" & host & ")(PORT=1521))" & _

                             "(CONNECT_DATA=(SERVICE_NAME=myOracleDatabase))); uid=Loginid;pwd=" & Password & ";"

con.Open strCon

3) Please correct me if I am wrong. Am I correct to say that I already my Microsoft ODBC driver for oracle on my machine since I was able to connect to Oracle 11g through Oracle ODBC driver configuration and I was able to connect to Oracle through  C:\Windows\SysWOW64\odbcad32.exe?  If the above statement was true , why it said that Microsoft ODBC Driver was not defined or specified?

4) If I was completely wrong about having Microsoft ODBC Driver on my machine, then what do I need to do in order to check

        4a) If there exists a Microsoft ODBC Driver on my machine?

        4b) How to install Microsoft ODBC Driver if I don't have it?

Many Many thanks for ALL of your wonderful helps!!!

To