Connection to Oracle LITE

DirkB · Post by **DirkB** » Wed 28 May 2008 09:15

Does anyone know how to establish a connection to an Oracle lite database (10.3.0.1.0)? The ODBC DSN works fine using the BDE, but we can not figure out how to make the connection using TOraSession.
Properties:
Direct=True
Username=system
Password=pwd
Server=odbc:theDSNname
This gives an error NET: Invalid port.

Plash · Post by **Plash** » Thu 29 May 2008 08:03

You should set Server property for Direct mode in the format
Host:Port:SID

DirkB · Post by **DirkB** » Thu 29 May 2008 08:32

What is the default port and SID for Oracle Lite?
Oracle Lite does not seem to have a listener process. The ODCB and JDBC connection work fine, and connecting using the .NET provider (a test in Delphi.NET) works too. I hope we can connect using ODAC because I want to loose the BDE!

Plash · Post by **Plash** » Thu 29 May 2008 09:04

ODAC does not support Oracle 10 Lite.

DirkB · Post by **DirkB** » Thu 29 May 2008 09:15

Please remove the reference to Oracle Lite from your website than!
I have a big problem now, starting with explaining to my boss that the product that I bought does not do what it advertises.

Plash · Post by **Plash** » Thu 29 May 2008 12:59

You are right, it was written at our site not quite correctly. ODAC supports only Oracle 8i Personal Lite Edition. We will make appropriate changes in the site.
As to your order, please contact us through sales*crlab*com.