0 Replies Latest reply: Jul 12, 2011 8:02 AM by 874917 RSS

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

    874917
      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?