personal Oracle 8i and 8ilite

[umayr]

Hi

I am using Delphi 5, DOA 3.3.3, Personal Oracle8i.

a) How can I connect to a Personal Oracle 8i
database using your components?
b) Any body with experience in this scenario?

Thanks in advance.
UShafeeu

 

[Marco Kalter]

You can connect to Personal Oracle 8i or 8i Lite like with any other Net8 client (e.g. scott/tiger). For 8i Lite you have to prefix the database name with odbc (e.g. odbcolite).

------------------
Marco Kalter
Allround Automations

 

[Garry]

I'm using DOA 3.22 & Delphi 4.
I can't connect to Personal Oracle Lite 2.4.3.1.1, but i have no problem with connection with ORACLE 7, which one has been installed under HP Unix.
When i invoke method LogOn (for POLite), raising an exception:
Initialization error
Could not find "ora73.dll"
When i use BDE, no problem was found.

What can i do to solve this problem?

 

[Marco Kalter]

Direct Oracle Access connects to Oracle Lite 2.4 through SQL*Net 2.3 (ora73.dll). The BDE probably connects through ODBC. Can you make a connection to your Lite database through SQL*Plus?

------------------
Marco Kalter
Allround Automations

 

[Garry]

Yes, I have no problem with connection through SQL*Plus.(Version 3.3.2)
SQL*Plus 8.05 is not working with POLite.

But ... I have no SQL*Net 2.3 Client. I use Net8 Client to all databases.

May be I need to install SQL*Net 2.3 Client?

Respectfully yours, Garry

 

[umayr]

Hi

Sorry, this may not be the forum for this but i was wondering,

1) How exactly does the DOA connect to Oracle Lite.? like
DOA -> ODBC -> SQLnet
or
DOA -> SQLnet -> ODBC

2) How can I connect to a remote Polite Database file eg : POLITE.ODB in another computer in the network.

3) I do not sure any 'listener' configurations or how sqlnet comes into play with no listeners?

Rgds
Umayr