ColdFusion 4.5.x: 'Unknown Connection' error when connecting to mySQL databases using myODBC for Solaris
When connecting to a MySQL database using the myODBC driver in Macromedia ColdFusion 4.5.x for Solaris, the name of the database being passed to the driver is converted to all uppercase letters. If the actual database name (as defined in MySQL) is lower or mixed case, any actions performed against that data source will fail with an 'Unknown Connection' error.
To resolve the issue, do one of the following:
- Create all MySQL database names in all uppercase letters.
- For existing MySQL databases, create a symbolic link to the existing database name:
- cd ~mysql (go to the directory containing the database)
- ln -s clientdb CLIENTDB (creates the symbolic link - replace both instances of CLIENTDB with your database name).
This content requires Flash
To view this content, JavaScript must be enabled, and you need the latest version of the Adobe Flash Player.
Download the free Flash Player now!
