Having trouble of Creating OLE DB Connection on Windows 2003 64bit with SQL 64bit using BI Studio 2003
- From: "Ken J. Zheng" <kjzheng@xxxxxxxxx>
- Date: Thu, 07 Dec 2006 15:14:31 -0500
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.
.
- Prev by Date: Webservice - ODBC - sqlServer
- Next by Date: SQL2000 SP4 and 64bit server with JetDriver...
- Previous by thread: Webservice - ODBC - sqlServer
- Next by thread: SQL2000 SP4 and 64bit server with JetDriver...
- Index(es):