Kbase P5591: Error during schema pull using ODBC DataServer from MySQL database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/29/2011 |
|
Status: Verified
SYMPTOM(s):
Error during schema pull using ODBC DataServer from MySQL database
Error during schema pull using ODBC DataServer
[Microsoft][ODBC Driver Manager] Driver does not support this function.
Error during schema pull using ODBC DataServer from MySQL database
FACT(s) (Environment):
Using MySQL ODBC driver 2.51
Database is MySQL database
Progress 9.1x
All Supported Operating Systems
ODBC DataServer
CAUSE:
The MySQL database is not a supported data-source for Progress ODBC DataServer
FIX:
Option #1
Use Microsoft?s ADO (ActiveX Data Object) technology via the ODBC protocol to connect to MySQL database from Progress ABL. Please reference Progress Solution 21356 for implementation details.
Option #2
This workaround applies to Progress 9.x only. Microsoft Access is no longer supported as a data-source for the ODBC DataServer in OpenEdge 10.x.
Connect through Access first to connect to MySQL database from Progress 4GL using ODBC dataserver. Progress ODBC DataServer connects to MS Access connected to MySQL Database.
This alternative can cause performance issues.