Solved

Native Handle problems with Oracle 8

Posted on 2001-07-03
4
302 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
[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
  • 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

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…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

730 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