ASP.NET and MySql

A

aggie

Guppy
Is there an issue for preventing MySQL connections from ASP.NET?

I'm at the end of my rope here trying to find what's wrong.

Any help is kindly appreciated.
 
Hi Yash, thanks for answering.

Never mind. I finally found what was wrong.

Thanks again for all your help and all the staff who have answered me.
 
I changed my code to use the .NET Connector instead of how I previously had it with ODBC. But the code was working as expected in my development machine, but not on the site. I did something really silly and it worked, I capitalized the table names on the MySql database. First time I've seen this happen, maybe it's the MySQL version, since it's different in my development computer than here. I don't know, but it seems as the table names are case sensitive. I just changed that on the db and the code worked.
I haven't tried the code as it was, using the ODBC driver. I'll give a try in the next couple of days and I'll keep you posted as to if it's working or not.

Thanks again for all your help. I do appreciate it.
 
Ah, the issue is that the MySQL servers are on unix, which is case sensitive, and you are using MySQL on windows, which is not.
 
You must log in or register to reply here.
Back
Top