I installed the Oracle instant 10 client (tested it with the sqlplus-tool, you can extra install. Connection succeeds. Now I wanted to test an connection with Microsoft Ole DB provider for Oracle, but when using test connection button, I get the message it can't find any of the Oracle components. What do I have to do more to get it working. I don't want to install a whole Oracle CD on it, can it work with the Instant client. Do I have to change some things in the register so the system knows where Oracle is?
in Oracle documentation I found this: To use the Microsoft ODBC and OLEDB driver, ociw32.dll must also be copied from ORACLE_HOME\bin.
but when copying that dll to my instantclient path, nothing changes (also that file already exists, only difference in bytes).