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

You needn't ignore the comments peter and i left you.

http://p2p.wrox.com/topic.asp?TOPIC_ID=60808

Don't cross post.

================================================== =========
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
================================================== =========

Sorry about that, got an error when I tried posting on tuesday and with watching the CL Final not had time. Did a quick search back to find it and it didn't appear to be there so posted again.