| Ken J. Zheng 2006-12-07, 7:12 pm |
| Here comes the problem.
1. We have a new server installed with Windows 2003 64bit Enterprise
edition plus SQL 64bit Enterprise edition.
2. We need to use Business Intelligence Studio to create a SSIS project
which will retrieve data from a Oracle database server. Inject them into
Sql database.
3. I downloaded the 10.2g Oracle Client (64bit edition for Xceon CPU).
Installation went well. I created a naming service in its Net Manager.
Test connection OK. Then, I went to administrator tools, Data Source
(ODBC), System DSN, add a new data source. I picked "Oracle in
OraClient10_home1", filled required information, tested connection, it
was OK.
4. Then, in the BI, when I tried to create the data source connection,
by selecting "new OLE DB Connection...", click "new" button, in Provider
dropdown, pick "Microsoft OLE DB Provider for Oracle" or "Oracle
Provider for OLE DB", both got the error of "OraOLEDBpus10.dll: The
specified module could not be found.".
Ok, then, since I found out BI is a 32bit application, it may not able
to use the 64bit component.
5. I installed the 32bit Oracle client from Oracle website, created a
naming service. In SysWow64 folder, find the odbcad32.exe, created the
connection, OK.
6. I still got the same error in BI Studio.
7. I tried on a 32bit OS with 32bit SQL 2005. No problem at all.
8. I also tried the Link Server, doesn't work out. Saying the Oracle1...
not registered.
Any solutions?
Thanks.
|