deploying to a 64 bit server

[tekkerguy]

I designed an etl program that pulls data from an oracle source and puts in into a sql database.

The oracle connector is 32 bit on my machine. I want to deploy this to a 64 bit server.

How do I make sure that it uses the 64 bit version of the oracle 10g client?

 

[mrdenny]

When installing on the 64bit machine only install the Oracle 64bit drivers on the machine and not the 32bit.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com