?
Solved

BDE & Personal Oracle

Posted on 1998-03-11
7
Medium Priority
?
390 Views
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?
0
Comment
Question by:gjbaker
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 

Expert Comment

by:chunhui
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.
0
 

Author Comment

by:gjbaker
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?
0
 
LVL 8

Expert Comment

by:ZifNab
ID: 1360419
First try the update of BDE.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Accepted Solution

by:
chunhui earned 300 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".

0
 

Author Comment

by:gjbaker
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.
0
 

Expert Comment

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

Author Comment

by:gjbaker
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.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month7 days, 23 hours left to enroll

765 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