Personal Oracle light (POL)
Posted: Thu 02 Dec 2004 08:22
How does one connect to a POL database with ODAC or DBExpress ?
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.