Dear MySQL community, I am new MySQL user. I want to migrate a M$ SQL Server database to MySQL in a Linux box. Since table names in MySQL@Linux is case sensitive, I am having troubles connecting to the server via ODBC from a Windows box.
I search the documentation and find that I may be able to disable the case sensitivity by setting the variable called lower_case_table_names to 1 when starting the server. I edit my.cnf and restart the server. Everything seems OK. mysqladmin and the Show Variables command in mysql confirm that this variable is now 1 instead of 0 before I make the changes. I have also changed the schema so that all table names are now in lower cases. However, when I perform a select, eg., SELECT * FROM Company; Then, an error occurs that tells me that the user xxx is not allowed select the table. Of course, there is no error when the following SQL is submitted: SELECT * FROM company; I change my.cnf back and repeat the above tests and the error persists. Thus, nothing seems to be changed by setting the variable. Have I missed anything? Thanks in advance. __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
