BDE ORA-03114: not connected to ORACLE

Problem:


BDE always cannot connect to Oracle database, even with proper configuration.
Tried with Ora10g, Ora11g, Ora12c. Oracle version does not matter.

This is the error:

 General SQL error.
ORA-03114: not connected to ORACLE


My configuration in BDE:

Configuration > Drivers > Native > ORACLE
DLL32: SQLORA8.DLL
VENDOR INIT: OCI.DLL

Approach:


On my Windows 8 & Windows 10 64 bit machines, BDE seems to only work fine BDE and it's .CFG path is short. Should be same for 32 bit machines too.
 


So the first thing to do when trying to run BDE in Windows 8 & Windows 10 machines is:
  1. Install BDE.
  2. Move the entire BDE installation directory (usually C:\Program Files (x86)\Common Files\Borland Shared\BDE) to (C:\BDE).
    (I copied mine to C:\BDE32)
  3. Right click > Run BDE as administrator.
    To ensure BDE runs with true administrator privilege, you may need this .manifest file, otherwise BDE may not respond or 'hang' on any 'Apply' changes.
  4. Right click Configuration > Open Configuration
  5. Select the default idapi32.cfg from C:\BDE
  6. Apply to use this .CFG file when prompted.
    Your BDE title should change to shorter path now.
  7. You should be able to login normally to your database now. 

Comments

Post a Comment