"rakesh pal" <rakesh.120980@gmail.com> wrote in message
news:O8pEpl7ZHHA.3612@TK2MSFTNGP04.phx.gbl...
>
>
> 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.
>
>
> *** Sent via Developersdex http://www.developersdex.com ***