<div>
Found the problem.<br />
<br />
It seems that MySQL v5.0 is case sensitive. So select * from USER_LOGIN table produces a table not found&nbsp;error while select * from user_login works!!<br />
Thank for all you help.<br />

</div>


Found the problem.

It seems that MySQL v5.0 is case sensitive. So select * from USER_LOGIN table produces a table not found error while select * from user_login works!!
Thank for all you help.


<div>
It's not that MySQL v5.0 is case sensitive. MySQL v5.0 is case sensitive with table names according to the underlying OS hosting it, because the tables has matching files created on the hard disk. Most Unix based OS have case sensitive file systems, while windows do not. So if the Mysql is hosted on Linux the table names are case sensitive. Windows on the other hand is not.
</div>


It's not that MySQL v5.0 is case sensitive. MySQL v5.0 is case sensitive with table names according to the underlying OS hosting it, because the tables has matching files created on the hard disk. Most Unix based OS have case sensitive file systems, while windows do not. So if the Mysql is hosted on Linux the table names are case sensitive. Windows on the other hand is not.

<div>
<div class="content wysiwyg-content">
I have created a shared Windows hosting account with GoDaddy. I also created a MySQL database and Web site. Using the same credentials I used to create the account I am unable to connect to the database with the connect string. I get the following error:<br />
<br />
Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [MySQL][ODBC 3.51 Driver][mysqld-5.0.37-log]<wbr />Table 'etnyadmin.USER_LOGIN' doesn't exist.<br />
<br />
Anyone know why?<br />

</div>
</div>


I have created a shared Windows hosting account with GoDaddy. I also created a MySQL database and Web site. Using the same credentials I used to create the account I am unable to connect to the database with the connect string. I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [MySQL][ODBC 3.51 Driver][mysqld-5.0.37-log]Table 'etnyadmin.USER_LOGIN' doesn't exist.

Anyone know why?


Godaddy shared windows hosting and MySQL

Networking is the process of connecting computing devices, peripherals and terminals together through a system that uses wiring, cabling or radio waves that enable their users to communicate, share information and interact over distances. Often associated are issues regarding operating systems, hardware and equipment, cloud and virtual networking, protocols, architecture, storage and management.

Networking

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.