SQL Navigator startup error: Unhandled Exception at startup – Cannot find OCI DLL: oci.dll

So, I copied all source to server, installed there Visual Studio and compiled project in x64 bit mode with x64 bit version of Oracle.DataAccess.dll. Despite the fact that this is not so good way, it eventually work now. Now all I need is to get access to repository from server for get source code every time I will compile it.

The error comes from regsvr32 and means orasql12.dll has a dependency that's not satisfied. Double-check with the documentation. Here's what I've found:

System Requirements

The following items are required on a system to use Oracle Provider for OLE DB:

• Windows 98, Windows NT 4.0, Windows 2000, or Windows XP
• Access to an Oracle Server (release 8 or later)
• Oracle Net Services
• Redistributable files provided with Microsoft Data Access Components (MDAC) 2.1 or higher are required by the provider. These files are available at the Microsoft Web site: www.microsoft.com/data/oledb/
• Oracle Services for Microsoft Transaction Server (release 9.0). This item is required for consumers using Microsoft Transaction Server (MTS) or COM+.

I have also found a thread on Oracle forums:

After some more research, I found the issue to my problem. In the readme.htm file that's included in the unzipped 64-bit providers folder, it explains that after you install the files through install.bat, you need to place the location you installed the files in the PATH variable for windows. For example, if you use the install.bat file to install the files at C:\Oracle, you need to place the paths "C:Oracle" and C:\Oracle\bin" in the PATH variable. You can find this variable by right-clicking on My computer and selecting Properties (for Windows Vista/7 users, it's right clicking on Computer then properties then advanced system settings). Click on the Advanced tab and click the Environment Variables button. In the Systems variables list, you'll find the PATH variable. I hope this helps someone else.... I worked on getting the oledb provider to work for days...

You can also use Dependency Walker to check by yourself. See here for more information.