Oracle archive on 64-bit system

Oracle archive on 64-bit system

Hi,
We have a problem to create SQL Archive on 64-bit Windows Server 2008 R2 platform and Oracle10.2 Database (64-bit client). When we set OLE DB source, test connection is successfull, but we have error with archive tables creation. And we can not create Oracle ODBC source in our system (no such driver in the system). On 32-bit test system (Windows XP) everything is OK. How can we resolve this problem?

This is a migrated post! Originally posted on 22.11.2009 by user okhotnikov. Please be aware that information can be outdated.