ASP, My SQL & case sensitity suddenly broken

We have an old ASPsite that has been working fine for years with a MY SQL database. All of a sudden last week lots fo SQL queries stopped working.

The database has a table called 'members' but the code calls 'Members'. It appears the queries used to work regardless of case sensitivity on the table names, but something has changed recently somewhere to enforce case.

This has me stumped as the site has not been touched in years, the server config hasn't changed & t开发者_运维知识库he database provide has not changed anything.

Is there any simple way to ignore case for an ASP site (without editing lots fo files :)

Thanks

Ben

Have a look at this page from the manual to learn about case-sensitivity and identifiers in MySQL.

Someone may have switched the lower_case_table_names toggle, or (as webdestroya comments) moved the database server from a case-insensitive OS (e.g. Windows) to a case-sensitive OS (e.g. Linux).