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

nissa...@planete.net (Nicolas Issakides)

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

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.

 
ovidi

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

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

1. Why Doesn't Delphi 2.0 Support win95 Toolbar

2. Delphi 2.0 - Data Pump doesn't work......

3. Delphi 2.0 tip: hPrevInst doesn't work!

4. Why can't I access SQL Server DMO collections from Delphi 2.0 with OLE Automation

5. Delphi 2.0 - Using TList Object's Sort Method

6. Problems with importing Delphi 2.0 DLL's in Delphi 2.0

7. OLE 2.0 in Delphi 2.0

8. [Delphi 2.0] [URGENT] Why does this not Work!!!

9. Delphi 2.0 OLE DLL registration for use with VB object browser

10. accessing ole object fields in MSAccess from Delphi 2.0