Any idea on connection string or any way on connecting to oracle lite database?
Connecting to Oracle Lite
Try to do the following. There is the only one way to connect to Oracle Lite with OraDirect using the following transfer way
[OraDirect] -> [OCI] -> [OCA] -> [ODBC] -> [Oracle Server]
For this purpose, please configure ODBC according to Oracle Lite documentation.
Please set
Data Source=ODBC:POLITE;
You can test connection to Oracle server using SQL Plus. Unfortunately this schema
works well for Oracle 8i Lite and does not supported in Oracle 9i Lite, Oracle 10
Lite.
You can work with Oracle Lite when
[OraDirect] -> [OCI] -> [OCA] -> [ODBC] -> [Oracle Server]
For this purpose, please configure ODBC according to Oracle Lite documentation.
Please set
Data Source=ODBC:POLITE;
You can test connection to Oracle server using SQL Plus. Unfortunately this schema
works well for Oracle 8i Lite and does not supported in Oracle 9i Lite, Oracle 10
Lite.
You can work with Oracle Lite when
Code: Select all
((CoreLab.Oracle.OracleCommand)cmd).FetchSize = 1;