Kbase 18907: Apptivity 3.0x and Later ODBC Drivers Don't Interact Cleanly
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/10/2004 |
|
SUMMARY:
When installing Progress 9.0a or 9.0b or any other product that will
install new ODBC managers and drivers (such as the Mdac MERANT data
access controls) specifically MSAccess driver 4.00.3711.11+ and the
new MERANT 3.50 Progress Drivers, Apptivity 3.0 does not interact
cleanly with these new versions. Apptivity 3.1 however does react
cleanly.
For instance, you might see an error when creating a datasource in
Apptivity. After choosing a table with the Apptivity Query Editor, clicking on the "columns" tab would generate a message stating that "Optional Feature not implemented."
Another possible error you might encounter occurs when saving a datasource is, "Unknown error when accessing database".
This is seen when using MS SQL server 7.0.
Using this new ODBC driver with the Northwind db, it was found that in
some cases the query file shows unknown data type codes being passed
at runtime. Code changes have been implemented into the Apptivity 3.1
release to translate these types to their equivalent java SQL types.
SOLUTION:
In order to correct the situation without having to upgrade to
Apptivity 3.1, you will have to go to your Office 97 Professional
Disk and copy the odbc*.* files from the CD to your winnt and
system32 directories. Just reinstalling the data access drivers will
not work since the application notices that the drivers you are trying
to install are older than the ones currently on your disk, and
therefore the copy is not initiated.