Re: Why using Oracle Objects for OLE 2.0 from Delphi 2.0 doesn't work ?

If the database is located on a server, try to replace MyDb with the real SQLNet definition This something like 'T:server:SID' for SQLNET 1 or 'server.World' for SQLNET 2

You can test the synthax from office tools from MS or from VB.

Also, insure that you dont mix a 16 or 32 bit Oracle OLE version with a 16 or 32 bit version of delphi.

In article <EIv2Dn.A2H_at_nonexistent.com>, "ovidiu" <ovidiuscripa_at_pentapro.ro> wrote:
>Pls. could someone tell me why this code doesn't work :
>
>var
> OraSession : Variant;
> OraDatabase : Variant;
>begin
> OraSession := CreateOleObject('OracleInProcServer.XOraSession');
> OraDatabase := OraSession.OpenDatabase('MyDB', 'scott/tiger', 0);
>
>At the last line I get the error : " project raised exception class
>EOleSysError with message 'Member not found'.
>
>Something similar in VB 5 works OK.
>
>Thank you.
>

Nicolas

Nissakid_at_planete.net
Microsoft Certified Product Specialist
AUI Member

The above represents my own opinion not my employer's and does not necessarily constitute the official policy of my employer. Any opinion developed through this account represent a private conversation. Received on Thu Oct 30 1997 - 00:00:00 CET