BDE & Personal Oracle

Posted on 1998-03-11
Last Modified: 2013-11-23
We have been running Delphi against a network version of Oracle for some time now.  We recently installed Personal Oracle 7.3 on a couple machines.  The problem is we can't seem to figure out how to set up a BDE alias to point to the local (Personal Oracle) database on the individual machine.  The Borland web sit does not seem to help out any.  Any suggestions?
Question by:gjbaker
  • 3
  • 3

Expert Comment

ID: 1360417
The Personal Oracle 's Net Protocol name is different from
the oracle server. It's '2:'. And The Server Name is
any character you want , it's not be cared.

Author Comment

ID: 1360418
Under BDE 4.0 we get the error message "NET PROTOCOL cannot have a value of 2:".  This is using the native Oracle driver.  Any other ideas?

Expert Comment

ID: 1360419
First try the update of BDE.
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.


Accepted Solution

chunhui earned 100 total points
ID: 1360420
Make sure you have a local ORACLE_HOME directory defined on each workstation.
When using Personal Oracle the "SERVER NAME" value in your BDE Oracle alias should be set to "2:" for Personal Oracle 7.1 and "2" (without the colon) for Personal Oracle for Windows 95.
Check your SQL*Net Client and Server versions. They should either match (i.e., SQL*Net 2.3 on both) or the client should be running a higher version.

It is very helpful to generate trace information while tuning your TNS connection. Set the TRACE_LEVEL_LISTENER entry of your LISTENER.ORA equal to "ADMIN", and the TRACE_LEVEL_CLIENT entry of your SQLNET.ORA  equal to "16". The trace files will show you the connection process step by step, including port, protocol, and packet information. They will even give you the complete error stack if your connection was unsuccessful, with all corresponding error numbers and full message text!
Once your connection is up and running, set the previous values back to "OFF".


Author Comment

ID: 1360421
I'm real close to having it working.  However, I get an invalid username or password when I try to login through Borland's Database desktop.

Expert Comment

ID: 1360422
Is it a ORA error? If is tell me the ORA ERROR number,
if not, look at your DLL file name.

Author Comment

ID: 1360423
Thanks for your help Chunhui, but my login error was really stupid.  I had setup the username for the BDE alias as 'P0(zero)7 instead of PO(as in Oracle)7.  After I changed that, it works fine.

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now