CODEWITHSUNDEEP
oracle-databaseexcelvbaadodb
moleboy
moleboy

Reputation: 864

Connecting Excel 2010 VBA to Oracle using 11g client

I have an Excel macro that I have used to connect to Oracle 10g just fine. I've brought that sheet over to a PC with the Oracle 11g 64-bit client installed, and Excel 2010, and now it doesn't work. I get an error along the lines of "Microsoft ODBC For Oracle The Oracle(tm) client and networking components were not found"

Help?

Upvotes: 1

Views: 3719

Answers (1)

moleboy
moleboy

Reputation: 864

Using the 32-bit client worked. :)

Upvotes: 2

Related Questions