DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using Oracle OLE Db Provider within Excel 2010 VBA Macro (Windows 7 64 bit)

874917Jul 12 2011

Hello,

i'm trying to connect within my Excel-Sheet (Windows 7 64 bit, Oracle client 10.2.0 32 bit, Excel 2010, VBA 7.0) to Oracle Database (oracle 10.2.0).

1. If i try to open the connection (ADO.Connection) i always get the following error:

ORA-01804: failure to initialize timezone information

2. Then i tried to test the provider with "test.udl" and i will get the same error:

ORA-01804: failure to initialize timezone information

What should i do, to get the connection, can anyone help me to solve the problem?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 9 2011

Added on Jul 12 2011

#oracle-provider-for-ole-db, #windows-and-net

0 comments

1,161 views