Kbase P54168: Error during schema pull using ODBC dataserver from MySQL database - Connecting to Access first
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/11/2009 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
ODBC DataServer
SYMPTOM(s):
Error during schema pull using ODBC dataserver
[Microsoft][ODBC Driver Manager] Driver does not support this function.
Using MySQL ODBC driver 2.51
Database is MySQL database
Not able to use MS ADO to access MySQL
CAUSE:
The MySQL database is not supported for Progress ODBC DataServer.
FIX:
ODBC dataserver does not support MySQL foreign data source.
To connect to MySQL database from Progress 4GL using ODBC dataserver, connect through Access. Progress ODBC DataServer connects to MS Access connected to MySQL Database. This alternative can cause performance issues.