I have pretty much read (I hope) all questions related to successfully connecting to an Oracle database using Microsoft ODBC Driver for Oracle. I even tried the following:
Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=UserName;Pwd=Secret
after replacing server, uid and password. I’m still running into trouble.
Has anyone really solved this other than those being lucky in the first attempt?
This solution does not say what version of windows they installed in. Besides, Oracle instant client is available in different flavors such as 64 bit, Base package, tools package etc and for various versions such as 12.2.0.1.0, 12.1.0.2.0, 11.2.0.4.0, 11.1.0.7.0 , 10.2.0.5 etc with 18.5.0.0.0 being the latest. I’m really confused as to what versions these are referring to.
I have installed Oracle database 11g version 11.2.0.1.0 64 bit.