Board index » delphi » Why using Oracle Objects for OLE 2.0 from Delphi 2.0 doesn't work ?

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....@nonexistent.com>, "ovidiu" <ovidiuscr...@pentapro.ro>
wrote:

Quote
>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

Nissa...@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.

 

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


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.

Other Threads