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.
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
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
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.
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.
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.
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)