MySQL Forums
Forum List  »  Full-Text Search

Unknown system variable 'character_set_results'
Posted by: Alyson Stibbard
Date: May 15, 2008 04:26AM

I am an Access and (relatively new) MSSQL user who is confronting MySQL for the first time. I am trying to link a table from a MySQL 4.0.24 database (on Linux) into a MSSQL 2005 database (on Windows Server 2003).

On the Linux server I have created a wildcard MySQL user who can connect from any host. On the Windows server, I have downloaded the MySQL ODBC 5.1 Driver and set up a Machine DSN to see if I can establish a connection. When I Test this DSN, MySQL seems happy enough with my login details but returns the message:

Connection Failed: [HY00][MySQL][ODBC 5.1 Driver]Unkown system variable 'character_set_results'

What do I have to do to MySQL to make it love me? If you have time to respond, please feel to treat me like I know almost nothing because, frankly, I know almost nothing.

Options: ReplyQuote

Written By
Unknown system variable 'character_set_results'
May 15, 2008 04:26AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.