Dirt McStain (10/20/2010)

---

Here's the main downloads page:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

If you click on see all next to Microsoft Windows (x64), it'll take you to this page:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

The second section contains...

If you are using MS OLEDB provider for Oracle.. it works only in 32-bit runtime environment.. there is no MS provider for oracle connectivity for 64-bit runtime environment.

try Oracle...

I am trying to get the 64 bit drivers.. the links given in the oracle site points to the failsafe versions of 64bit drivers.. where to get the 64bit ODAC...

interesting...

yuck... i mistook the question as how many rows (instead of columns) will be returned and chose a wrong answer... my bad...

Hugo's explanation had more about this question.. Thank you both..

interesting qotd...thanks for enlighting on the difference

Nice questions from which i learned more about schemas.. Never knew Schema has this much to do..

I have done something similar... but in my case excel source was dynamic..

I have set the connectionstring expresssion value of Excel connection manager as below

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ @[User::filepath]+";Extended Properties=\"Excel 8.0;HDR=YES\";"

I have...