[Webinar] Streamline your web hosting managementRegister Today

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

Native Handle problems with Oracle 8

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
rikjc
Asked:
rikjc
  • 2
1 Solution
 
SChertkovCommented:
What version of Oracle Client you installed,
and what SQL Link drivers (for 8.0 or 7.3) you used ?
0
 
fvaCommented:
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
 
rikjcAuthor Commented:

I figured out that the LDA was no longer supported under 8 OCI. However thanks for the feedback.
0
 
fvaCommented:
Well, since then 9i is out and already wearing out :)
However, thank you for the points.

F.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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