Re: Having trouble of Creating OLE DB Connection on Windows 2003 64bit with SQL 64bit using BI Studio 2003

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

we had this problem also; I don't think that x64 is ready for primetime


"rakesh pal" <rakesh.120980@xxxxxxxxx> wrote in message
news:O8pEpl7ZHHA.3612@xxxxxxxxxxxxxxxxxxxxxxx


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 ***


.

Relevant Pages

  • Re: ORA-03114 Not Connected To Oracle problem.
    ... >Terminal Services and all the sessions are handled by one server. ... >and only one connection to Oracle will fail. ... Likely this is a result from shared pool ...
    (comp.databases.oracle.server)
  • RE: :Oracle - with ora10g oci.dll
    ... You are likely running into a bug with Oracle 9.2. ... A little research on MetaLink should turn up the bugs. ... > The connection is correct. ... > 10g installation is really just a few files in the /perl/bin directory. ...
    (perl.dbi.users)
  • Loss of internet connectivity on server
    ... I have a SBS 2000 installation with 2 NIC's that has been running flawlessly ... and rebooted the server. ... Double-clicking the Internet Connection icon on the taskbar fails to ... When rebooting the server, Windows hangs indefinitely at the step named ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Oracle connection Fails
    ... That should show you what's attempting to be sent to the server. ... to connect to the oracle database by using Oracle data provider ... from Our main server i am getting an exception. ... Connection conn, IntPtr opsErrCtx, Object src) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Limited or no connectivity after SP1
    ... It is not a fresh W2K3 installation, it is an upgrade on top of W2K3 ... >> After instelling W2K3Server SP1 the LAN connection has an error ... The server has 2 NIC's one that connect's to the ...
    (microsoft.public.windows.server.networking)