September 16, 2016 at 9:52 am
I typically install the Oracle 12.x client on our newly built SQL Servers (2012, 2014). Our Development Mgr identified a good point – we need to install the Oracle client that includes ODAC.
I’ve located & installed the 64-bit version of the Oracle 12.x client which includes ODAC from here:
-- 64-bit Oracle Data Access Components (ODAC) Downloads: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
I’m confused on which 32-bit version of the Oracle 12.x client to download and install (Xcopy, NuGet, ODP.NET, etc ???) found on this page:
-- 32-bit Oracle Data Access Components (ODAC) and NuGet Downloads: http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html
QUES: Can anyone tell me which 32-bit Oracle Client w/ ODAC file I should be dowmloading from that page?
thx in advance
September 16, 2016 at 10:06 am
Thus far, I've had the best luck using the XCopy client. It's a bare minimum, but make SURE you read the documentation before trying to load it. We need it for linked server connections to various Oracle RDBMSes and install only the OLEDB provider.
(As a side note, this is also the client my fellow DBA, an Oracle DBA, recommended, so it's got that going for it)
November 14, 2016 at 6:47 am
Hi,
if you Google "Oracle Data Access Components" you get exactly the link you need.
Since I have been able to convince the developers that OLE-DB is a vast improvement over ODBC it is exactly the way I have been providing the connectivity Services for them....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply