Page 1 of 1
Connection to Oracle LITE
Posted: Wed 28 May 2008 09:15
by DirkB
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.
Posted: Thu 29 May 2008 08:03
by Plash
You should set Server property for Direct mode in the format
Host:Port:SID
Posted: Thu 29 May 2008 08:32
by DirkB
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!
Posted: Thu 29 May 2008 09:04
by Plash
ODAC does not support Oracle 10 Lite.
Posted: Thu 29 May 2008 09:15
by DirkB
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.
Posted: Thu 29 May 2008 12:59
by Plash
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.