Connecting to Oracle Lite

Connecting to Oracle Lite

Postby Damaji » Thu 10 Feb 2005 19:54

Any idea on connection string or any way on connecting to oracle lite database?
:cry:
Damaji
 

Postby Paul » Mon 14 Feb 2005 11:40

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
Code: Select all
((CoreLab.Oracle.OracleCommand)cmd).FetchSize = 1;
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle