Hi All,

I am setting up an ASP.net 2.0 website with a MySql 4.1 backend. I am using the ODBC 3.51 to connect to it.

The website has a mix of coded DB retrieval functions in VB.net and binded controls. This all works fine in the development server at home, but I recently tried putting it on a live server hosted by GoDaddy. Any vb.net code DB access works fine, but the bound controls comes back with

"ERROR [HYT00] [MySQL][ODBC 3.51 Driver][mysqld-4.1.22-max-log]SELECT command denied to user 'admin'@'server' for table 'regions' "

I can use this account in code and see that table, but not in a bound combo box. I have emailed GoDaddy but they can't provide coding support.

They offer 2 help info sheets

http://help.godaddy.com/article.php?...3&topic_id=102
http://help.godaddy.com/article.php?...0&topic_id=102

If I try the DSN it does the same thing.

Any help would be appreciated.

Regards

DJIDave

Look a the error again:

"ERROR [HYT00] [MySQL][ODBC 3.51 Driver][mysqld-4.1.22-max-log]SELECT command denied to user 'admin'@'server' for table 'regions' "

This would indicate to me that you are connecting to the database just fine, but the db permissions are denying the user select access to the table, as the error describes. You need to set the right permissions on the tables for the user you'll be connecting as.

-Peter

Peter is quite right, void of your application if you logged into the server through, say Query Browser, you would get the same error.

To correct this, you should log into MySQL Administrator as root (or any other power user who has the ability to change user rights) goto the user administration and select your admin user, view there permissions, and then grant them permissions to the entire database you are trying to select from.

(This can also be done through a MySQL shell, but I can't quite remember the commands to change user rights through the shell)

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

The issue is that the user has the correct rights. I can use that user and connect in vb.net code that is behind the asp page, using the odbc connection class and everything works fine. It is just bound controls that fail with this error. I can log in to PHPmyAdmin with the user name and it can see everything ok (this is the main admin account of the database).

It is only combo boxes and dataviews which have been bound using a sqldatasource which don't work. I have tested the SQL that is in them and it works in code and in the admin screen.

Thanks in advance

DJIDave

Show me your code, this doesn't make sense.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

I traced the problem down thanks to yourself. The designer was showing the tables as tablenamewhereas in the code it was database.tablename and the database name had changed.

Thanks for your help

DJIDave