![]() You can also use ODAC XCopy to install the Oracle Instant Client which supports ODBC. Using ODAC XCopy you can install 64-bit or 32-bit OLE DB drivers for Oracle. If you need 32-bit drivers, you will have to use the command-line ODAC XCopy. ![]() The ODAC OUI gives you a graphical user interface for installation, but it only provides you with 64-bit version of the drivers. Oracle provides ODAC Runtime Downloads, which contains drivers for Windows. Here is how we solved it! Installing Oracle OLE DB drivers on Windows So we needed to have Oracle OLE DB 32-bit and 64-bit drivers side-by-side. The problem was that the SSIS development environment uses 32-bit OLE DB drivers, but the SSIS runtime uses 64-bit drivers (this could be changed to 32-bit, but it was not a good solution). Last year I was working on a Data Warehouse project where we were going to use SSIS (SQL Server Integration Services) to read data from an Oracle Database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |