QUEST SQL Navigator 3.2 with Oracle 10g Fails

The SQL Navigator 3.2 fails to connect to Oracle 10g. Oracle 10g is on a Windows 2003 Server. The Navigator is running on a Windows XP Pro v2002 workstation. This software is a debugger for Oracle stored procedures and scripts. The error message states: Error: 1.0.[Load interface dll's failed.0] The SQL Navigator 3.1 worked under Windows XP workstation connecting to Oracle 7 on a Windows NT 5.1 Server. Any ideas! Thanks

2 more comments
Anonymous Dec 26, 2007

I get the same error while trying to connect to Oracle 10g:

sql navigator error 1.0 (load interface dll's failed)
Anonymous Jul 25, 2008

[Load interface dll's failed.0 [Load interface dll's failed.0
Anonymous Jan 27, 2009

Unhandled Exception at startup - Invalid filename

Report the problem to Quest Support. Application will be terminated (some memory loss is possible) when you press OK.
Anonymous Feb 28, 2009

i have SQL Navigator v 4.1 and can't connect to oracle 10g

4 Answers

Anonymous

Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.
Contributor
1 Answer

I followed the advice given above and copied the ORACLE_HOME/bin/ociw32.dll to ora73.dll in the same directory. copy ociw32.dll ora73.dll
And the software worked immediately.

Posted on Sep 12, 2008

Anonymous

Level 1:

An expert who has achieved level 1.

Mayor:

An expert whose answer got voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.
Contributor
4 Answers

I'm sorry but I'm not familar with this software. I will change my posting. I know dos allot and awk.

Posted on Jun 23, 2007

Anonymous

Level 1:

An expert who has achieved level 1.

Mayor:

An expert whose answer got voted for 2 times.
Contributor
1 Answer

In registry
Ora8 - HKLM\Software\Oracle\ALL_HOMES
Ora10 - HKLM\Software\Oracle\KEY_OraDb10g_home1
- Its the folder that points to the dll's that the Navigator uses.
copy all keys from that folder to
HKLM\Software\Oracle

Posted on Aug 18, 2009

Anonymous

Copy ORACLE_HOME/bin/ociw32.dll to ora73.dll in the same directory. In my case it helped.

Posted on Feb 19, 2008

Add Your Answer

Upload

Upload an image from your computer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

Loading...

Include an image. It's worth a thousand words.

prev next

Related Questions:

1helpful

1answer

I installed oracle 10g express edition.now I dono how to remove it. please let me kno how to uninstall it.I even stopped the oracle services but i dino abythin further.

Follow these steps:

Open the Windows Services utility: From the Start menu, select All Programs, then Administrative Tools, and then Services.
If any of the following Oracle services exist and have the status Started, then select each of the services, and click Stop:
- OracleXE
- OracleXETNSListener
- OracleJobSchedulerXE
- OracleXEClrAgent
- OracleMTSRecoveryService
Exit Services.

See also the Microsoft online help for more information on stopping services.
7.2.2 Step 2: Remove the Oracle Database XE Registry Editor Settings Follow these steps:

Log on to Windows with Windows administrative privileges.
Ensure that you followed the instructions under "Step 1: Stop the Oracle Database XE Services" to stop the Oracle Database XE services.
Start the Registry Editor at a command prompt:
SYSTEM_DRIVE:\> regedit
Go to HKEY_CLASSES_ROOT.
Delete the following keys:
- NEED TO CONFIRM THE XE-SPECIFIC ONES.
Go to HKEY_CURRENT_USER\Software.
Under Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs, delete the Oracle Database 10g Express Edition key.
Go to HKEY_LOCAL_MACHINE\SOFTWARE and search for the ORACLE group key.
Expand the ORACLE group key and then delete the KEY_XE and OracleMTSRecoveryService keys.
Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI.
Expand the ODBCINST.INI key and remove the Oracle in XE key.
Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services.
Delete the following keys:
- OracleServiceXE
- OracleXEClrAgent
- OracleXETNSListener
Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application.
Delete the Oracle.xe key.
Exit the Registry Editor.
Restart your computer.

7.2.3 Step 3: Update the System Variable Path Follow these steps:

Open System from the Control Panel.
In the System Properties dialog box, click the Advanced tab, then click the Environment Variables button.
Select the system variable Path and edit the Path variable to remove the Oracle Database XE entry. For example:
C:\oraclexe\app\oracle\product\10.2.0\server\bin;
Save your changes and then exit the Control Panel.

7.2.4 Step 4: Remove Oracle Database XE from the Start Menu and Desktop Follow these steps:

Select Start, then All Programs, and then Oracle Database 10g Express Edtion.
Right-click Oracle Database 10g Express Edtion and from the menu, select Delete.
On the desktop, right-click the Get Started with Oracle Database 10g Express Edition icon and from the menu, select Cut.

7.2.5 Step 5: Remove the Oracle Database XE Directories Follow these steps:

Ensure that you have followed the instructions under "Step 1: Stop the Oracle Database XE Services" to stop all Oracle Database XE services.
From the Windows Explorer, navigate to the directory where you installed Oracle Database XE, for example, c:\oraclexe.
Right-click the Oracle Database XE installation directory and from the menu, select Delete.

7.2.6 Step 6: Install and Run the Windows Installer CleanUp Utility Run the Windows Installer CleanUp utility to remove the Windows Installation configuration information for the Oracle Database XE installation. You can download it from Microsoft at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;290301
he deinstallation completes, click Finish.

Read full answer

Sep 14, 2010 • Oracle Database 10g

0helpful

1answer

How to convert sdf file in xls file ?

SDF file is a compact relational database also called a SQL server database. Designed for the application that runs on mobile devices and desktop.
If you only want to access SDF files in Excel sheets then you can see your SDF files in SQL Server or Visual Studio.

Read full answer

Jul 26, 2010 • Oracle 10g Database Standard (ODBSEONUPP0)

2helpful

4answers

Whst is the difference between .mdf,.ldf & .sdf?

LDF - layered data file, is the transaction log file for your database. It allows you to roll back changes you made to the data to a particular point and is used in rebuilding the data should it become corrupted.

MDF - Meta data file, is your actual data

SDF - Is a sequential data file, a flat file that can be used for compatibility with MS-SQL server, MySQL, etc.

Read full answer

Dec 03, 2009 • Oracle 10g Database Standard (ODBSEONUPP0)

0helpful

1answer

What is an sdf file and how it creates from which application.

.SDF File Extension (SQL Database File), the filef ormat for Microsoft SQL Server Compact databases.

Please rate this a fixya

Read full answer

Jan 30, 2009 • Oracle 10g Database Standard (ODBSEONUPP0)

0helpful

1answer

Oracle SQL Error

Does it connect after the error ?. First try to connect from your client to Oracle server using SQL plus client.

Second - Do a tnsping <server name>

This will give you the correct Host name, SID and Port number.

Make sure that your JDBC connection parameters match with the actual connection from TNS output

Read full answer

Sep 04, 2008 • Oracle 10g Database Standard (ODBSEONUPP0)

0helpful

2answers

Can we install Server component in Vista Home Basics

Hi,

I see no reason why you cannot do so. Just make sure you find all the drivers for you laptop before you migrate.

Read full answer

Apr 18, 2008 • Microsoft Windows Vista Ultimate Edition

0helpful

1answer

Network and sql serivices failed during startup windows 2003 server os

Check all this----------

1-check the services (stop the service & start the service from the services)
2-check the firwall setting.
3-check the n/w card
4-Remoove the unwanted s/w
5-check pc for the viruses

I think this activity help you.

Read full answer

Mar 07, 2008 • Microsoft Windows Server Standard 2003 for...

12helpful

2answers

What is a .sdf file? How to generate a .sdf file using ms access?

Regarding what is .SDF -- A file format that is compliant with the combination of SQL Server 2005 Compact Edition, SQL Server 2005 and Visual Studio 2005 to build, test, deploy, and manage applications for users. Databases of this type can be accessed directly as a datasource, e.g., from Visual Studio 2005, or from SQL Server Management Studio. As such, they can be passed around with programs or projects, although they are mainly used for embedded applications. The file includes all necessary code points to access the data, and so does not require an instance of SQL Server to be installed.

You can create a .SDF file with a software called PocketSYNC. (Although i have never tried it myself, a lot of people claim that this software works like charm. But it is not free)

Read full answer

Oct 17, 2007 • Oracle 10g Database Standard (ODBSEONUPP0)