Solved

Native Handle problems with Oracle 8

Posted on 2001-07-03
4
295 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
Comment Utility
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
Comment Utility
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
Comment Utility

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
Comment Utility
Well, since then 9i is out and already wearing out :)
However, thank you for the points.

F.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

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…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

771 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