APPX is the Premier Development and Runtime Environment for Business Application Software
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX System Administration :
Our developers wants to know if Appx has Dharma JDBC Driver?
Appx doesn't have Dharma JDBC driver, but does have Dharma ODBC driver. Depends on what users are trying to do/access. The AppxODBC driver (Dharma ODBC) lets you read/write Appx-hosted data (that is, data stored in an AppxIO file) from some other application, i.e. Access, SQL, Postress or Oracle.
You can certainly use the AppxODBC driver with a Java program. AppxODBC will function as a type 1 JDBC driver. A type 1 driver uses the JDBC/ODBC bridge to connect a Java application to an ODBC data source (a very common practice). Type 1 drivers don't perform as well as a type 4 driver, but that may not be a problem (in fact, given the performance of a typical Java application, the difference between a type 1 driver and a type 4 driver may be undetectable).
When you use the JDBC/ODBC bridge, the JDBC URL is structured like this: 
 jdbc:odbc:appxodbc
If you want to include the username and password in the URL: 
 jdbc:odbc:appxodbc;UID=appx;PWD=password

[Append to This Answer]
2005-Feb-08 9:11am
Previous: (Answer) List of Environmental Variables
Next: (Answer) Is there an environment variable that records a log of the user interface?
This document is: http://board.appx.com/cgi-bin/fom.cgi?file=552
[Search] [Appearance]
This is a Faq-O-Matic 2.719.
Copyright 2003 by APPX Software, Inc. All rights reserved.