О Компании Как Купить Скидки Продукты Услуги Тех.Поддержка Вопросы Карта Сайта

Oracle to Access FAQ

[Oracle-to-Access homepage]  [Download Oracle-to-Access]  [Buy Oracle-to-Access]

On this page you can find the most frequently asked questions regarding Oracle-to-Access converter. If your question is not answered here, please contact us at support@convert-in.com

What doesn this error means: "The application has failed to start because OCI.dll was not found"?
OCI.DLL is supplied by the Oracle Corporation and is a part of the Oracle version 7.3.4 (or later) client software installation. You need to install Oracle client and networking components on your system to use Oracle-to-MySQL. Also, please make sure that the path to Oracle components folder is in $PATH system variable.
Go to Top

I have multiple Oracle homes installed on my system. Can this cause a problem while using Oracle-to-Access converter?
Yes, it will be a problem, since the program doesn't know to which Oracle home it should connect. You can resolve this using TNS_ADMIN environmental variable to point to the directory where you wish to take tnsnames.ora from. Or you can set TNS_ADMIN parameter in the Windows registry as follows:
1) open regedit
2) go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
3) you will find subkeys named HOME0, HOME1, etc. Select the one you wish to use with Oracle-to-Access converter.
4) add TNS_ADMIN variable for this home and enter the path to tnsnames.ora file in this variable
Go to Top

What are the system prerequisites for Oracle-to-Access?
At least 32 MB RAM, MS Access 7.0 or higher, Oracle client and networking components must be installed.
Go to Top

What if I don't have direct connection to Oracle server?
You need to export Oracle database into dump file using Oracle EXP tool (see manual on this tool). Then you can convert that dump file into MS Access format using our OraDump-to-Access converter.
Go to Top

Does Oracle-to-Access converter support automation?
Oracle-to-Access converter does not support automation directly. However, there is console version of the program o2aagent.exe in the installation directory. It supports command line arguments and can be called from any script. So, it is possible to write a simple batch script and execute it recurrently using any Windows scheduler. Please refer to 'Command line' article of the product documentation for the further information.
Go to Top