DOA and Oracle Lite

[Eric^2]

I may need to port an application (C/S DOA+Oracle 9i) to Oracle Lite and was wondering what all I'd need to change on the client. It's pretty simple, uses no stored procedures or functions, and weighs in at around 200MB.

How does DOA work with Lite, and would you recommend an alternative solution. 10 to 20 clients, replicated with the server.

 

[GI]

Don't know for for sure about Oracle 9i but for Oracle 8i the Oracle Lite uses ODBC. So you can't use DOA for Oracle Lite.Of course I may be wrong..

------------------

 

[Marco Kalter]

Direct Oracle Access can connect to Oracle Lite databases through the Oracle Net Open Client Adapter for ODBC. See the "Personal Oracle Lite compatibility issues" chapter in the help file or User's Guide.