Kbase 18480: Apptivity And ODBC Datasources On Win95 With Office 95
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Apptivity 3.x
SYMPTOM(s):
When Apptivity 3.0 is installed on a Windows 95 machine with MS Office 95 (Office 95 MS Access Drivers), the ODBC datasources are created, but may not use the correct path to point to their corresponding databases.
If you try to run a project which uses such a datasource, an error dialog with the following error will appear:
Connection to <dbname> failed: Connection failed(3): No data found.
And the following exception will be generated:
java.sql.SQLException: No data found
FIX:
This can be corrected manually. Assuming that MS Office 95 ODBC Drivers are installed, go to Settings > Control Panel > 32bit ODBC, and for each of the Apptivity-created sample data sources, set the path so that it points to the corresponding database, as follows:
1) Appstar: <install-dir>\Samples\HTML\Appstar\sports.mdb
2) BasketBall: <install-dir>\Samples\Java\West_Stats\Basketball.mdb
3) Northwind: <install-dir>\Samples\Java\Northwind\Northwind.mdb
4) Netline: <install-dir>\Samples\Java\CompanyDir\Netline Traders.mdb
5) ShopCart: <install-dir>\Samples\HTML\ShopCart\shopcart.mdb
Note: <install-dir> is the Apptivity installation directory.