Connecting to Oracle Lite

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply

Connecting to Oracle Lite

Post by Damaji » Thu 10 Feb 2005 19:54

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

Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by 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

You can work with Oracle Lite when

Code: Select all

((CoreLab.Oracle.OracleCommand)cmd).FetchSize = 1;

Post Reply