Oracle Provider for OLE DB connection

[Former Member]

Testing connection to database with Oracle OLE DB in IdM 7.2 sp6 gives me this error: Test connection failed because of an error in initializing provider. ORA-01804: failure to initialize timezone information.  Has anyone else run into this? 

[thiago_cavalheiro]

Hello Chris,

Make sure you have the proper OLE DB/client installed - 32 or 64bit, your environment is ok and your tnsnames.ora (in case you arew using it) is correct. If those are all correct, you may need to reinstall your client/OLE DB. Are you able to connect to the database using other methods?

Best regards,

Thiago