I have the Oracle Runtime 11g 32 bits and the 12c Runtime 64bits instaled on my system, and i would like to know if is possible to use the 32bits Oracle 11g(126.96.36.199) ODBC driver on my Excel.
I have Office 365 32bits installed and need to use the Provider=OraOLEDB.Oracle but when i try to connect i have a error who says i can't connect to the DB.
I do not understand why. The Office can't use the 32bit OLEDB dll, since i aready have on my system ?
Is possible to specify whats plugin to use on the Excel connection string ?
Another thing, when i try to do a TNSping, is possible to specify the Oracle 11 32 bits TNS ping utility instead the default 12c 64bits ?