Opened 14 years ago
Closed 14 years ago
#588 closed defect (fixed)
ODBC: Connection fails for mySQL 5.1
| Reported by: | gavincramer | Owned by: | gavincramer |
|---|---|---|---|
| Priority: | major | Milestone: | 3.5.0 |
| Component: | MySQL Provider | Version: | 3.4.0 |
| Severity: | 2 | Keywords: | |
| Cc: | External ID: |
Description
Using the ODBC Provider to connect to a MySQL 5.1 database (using the MySQL 5.1.5. Connector) always fails when describing schema. In particular, if the database contains FDO metaschema (as created by the FDO MySQL Provider), it will wrongly try to interpret that metaschema and produce an error with the following text...
"You have an error in your SQL syntax: check the manual that corresponds to your MySQL server version for the syntax to user near '"f_options "f_options' at line 1"
I have a fix available, which addresses the metaschema handling as well as a change of the Connector DLL's name with MySQL 5.1. However, due to MySQL defect 41796 (see http://bugs.mysql.com/bug.php?id=41796), I will not be able to update the unit test's automatic creation of a DSN. The unit test will have to be left runnable only using MySQL 5.0 for the time being.
Change History (2)
comment:1 by , 14 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:2 by , 14 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
Fixed metaschema check and Connector DLL name check. The DLL name check now looks at a substring of the name, excluding the version number.
Modified: K:\fdo_trunk\Providers\GenericRdbms\Src\ODBCDriver\connect.c Modified: K:\fdo_trunk\Providers\GenericRdbms\Src\ODBCDriver\constants.h Modified: K:\fdo_trunk\Utilities\SchemaMgr\Src\Sm\Ph\Owner.cpp