Page 1 of 1
Oracle9i Lite
Posted: Fri 03 Dec 2004 09:47
by OlegProv
Hi, All!
How does one connect to a Oracle9i Lite database with ODAC ?
If it is possible more in detail
Thanks in advance, Oleg.
Posted: Fri 03 Dec 2004 13:42
by Paul
There is the only one way to connect to Oracle Lite with ODAC using the following transfer way
[ODAC] -> [OCI] -> [OCA] -> [ODBC] -> [Oracle Server]
For this purpose, please configure ODBC according to Oracle Lite documentation. Please set
OraSession.Server = 'ODBC:POLITE';
You can test a connection to Oracle server using SQL Plus. Unfortunately this schema works well for Oracle 8i Lite and does not supported in Oracle 9i Lite.
Posted: Tue 07 Dec 2004 08:51
by Guest
Paul wrote:Unfortunately this schema works well for Oracle 8i Lite and does not supported in Oracle 9i Lite.
Through TBDESession too it is impossible to be connected to Oracle9i Lite?
Posted: Wed 08 Dec 2004 07:31
by Paul
The problem is in OCA.
You can try to connect to Oracle 9i Lite using TBDESession and configure BDE alias to ODBC.
Posted: Wed 08 Dec 2004 09:45
by OlegProv
Paul wrote:You can try to connect to Oracle 9i Lite using TBDESession and configure BDE alias to ODBC.
BDESession.Connect; --- OK
OraQuery.Open; --- Error: OCI function is not linked
What to do?
Posted: Tue 14 Dec 2004 16:34
by Paul
Sorry, TBDESession cannot be used for ODBC connection. TBDESession is used for Oracle
only.
Oracle 9i Lite, Oracle 10g Lite do not support OCI interface for connecting to local
database. It is supported ODBC and JDBC interfaces on Mobile Client side starting
from Oracle 9i Lite. So ODAC cannot be used in this situation.