Solved

Native Handle problems with Oracle 8

Posted on 2001-07-03
4
300 Views
Last Modified: 2010-04-06
I am having problems obtaining the native database handle (LDA) from an Oracle 8 database. The code I am using works with Oracle 7.3 but not for 8? Any ideas or a solution would be appreciated.

function GetNativeDBHandle(var NativeHandlePtr: Pointer): Word;
var LDAHandleBuf : array [0..68] of byte;
begin
  Result := 0;
  // Get the native handle to the database...
  DbiGetProp(hDBIObj(database.Handle), dbNATIVEHNDL,  @LDAHandleBuf,
    sizeof(LDAHandleBuf), Result);
  NativeHandlePtr := @LDAHandleBuf;
end;
0
Comment
Question by:rikjc
  • 2
4 Comments
 
LVL 2

Expert Comment

by:SChertkov
ID: 6251684
What version of Oracle Client you installed,
and what SQL Link drivers (for 8.0 or 7.3) you used ?
0
 
LVL 4

Accepted Solution

by:
fva earned 50 total points
ID: 6251719
The Oracle API layer under BDE has changed from 7.3 to 8. BDE is using LDA and normal 8 OCI operations are based on service context. Since I presume you are using OCI calls with that LDA you got on 7.3, take a look at OCI 8 doc, especially at "OCILdaToSvcCtx()".

F.
0
 

Author Comment

by:rikjc
ID: 7323970

I figured out that the LDA was no longer supported under 8 OCI. However thanks for the feedback.
0
 
LVL 4

Expert Comment

by:fva
ID: 7324413
Well, since then 9i is out and already wearing out :)
However, thank you for the points.

F.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
calling Tcolordialog in dll make the form disappear 8 111
oracle global variables 4 68
Delphi 2 59
Convert GUI app into console app for Win32 Env 5 99
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
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…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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