• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 778
  • Last Modified:

Oracle ODBC driver 64 BIT install

Hi Experts

I have a linked SQL server running of 32bit Windows 2003, Im using the Ms OLE DB provider for oracle, I want to migrate this to 64 Bit windows 2008, Iv done some research and there does appear an Oracle drive for the job, however I havent got the foggest on how to install this does any one have guide or an point me in the right direction?
0
MrDavidThorn
Asked:
MrDavidThorn
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
If you downloaded the driver from oracle.com, ther will be a read me or installation guide that comes with it.

I suggest the Oralce Instant Client with ODBC:
http://www.oracle.com/technetwork/topics/winx64soft-089540.html

Basic first then the ODBC add on
0
 
MrDavidThornAuthor Commented:
ok iv download from the links but cant find any installation guide,

I did look at installing from link

http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

but that may no sense either.
0
 
slightwv (䄆 Netminder) Commented:
It is a little obscure but on the instant Client download link above, scroll all the way to the bottom: Installation Steps

With the Instant Client there really isn't an install.  Just unzip, create the network/admin/tnsnames.ora file and you are done.

With the ODBC add-on, just copy the contents in that zip to the same folder as the instant client.

With the ODAC, there should be a read me of some type.  It has been a while since I installed this but with the XCOPY version I remember something like an install.bat.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now