[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

BDE & Personal Oracle

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?
0
gjbaker
Asked:
gjbaker
  • 3
  • 3
1 Solution
 
chunhuiCommented:
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.
0
 
gjbakerAuthor Commented:
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?
0
 
ZifNabCommented:
First try the update of BDE.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
chunhuiCommented:
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".

0
 
gjbakerAuthor Commented:
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.
0
 
chunhuiCommented:
Is it a ORA error? If is tell me the ORA ERROR number,
if not, look at your DLL file name.
0
 
gjbakerAuthor Commented:
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.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now