Newbie needs help

williamg

I am new with PHP and MySql. I have a Script on a site that I designed for a Church. On my server, it works perfectly...(See http://www.premierewebdesign.net/Dan/NEW2/Events/index.php) However, when I try to load the page on the Church's site, I get this message....Client does not support authentication protocol requested by server; consider upgrading MySQL client....
(See http://www.reservationprocessing.net/lfbc/Events/index.php) ..Both are using MySql 4. I don't have any idea what this message means.. 😕 😕 😕 ..Any help will be appreciated.

williamg

I now know what the problem is but I do not know what to do about it.....This site is on a Windows server. I have been told that I will have to use ASP to connect to the database. Maybe with a script similar to this

DRIVER={MySQL ODBC 3.51 Driver}; SERVER=p41mysql31.secureserver.net; PORT=3306; DATABASE=lfbc1; USER=lfbc1; PASSWORD='your password here'; OPTION=0;

I am lost. I know nothing about ASP. I can only assume that I will need to create an ASP config file. But will the ASP then interact with my PHP script to read the database? Or is this whole project going to have to be rewritten in ASP? 😕 😕 😕 😕

bradgrafelman

I don't see why you would be required to use ASP... PHP should be able to do just fine. Look at either the [man]MySQLi[/man] or [man]ODBC[/man] libraries.

williamg

I will try that. You are probably right. When I couldn't get it to connect, I called GoDaddy and that is what they told me. But I am new to PHP and so I wasn't sure. I do now that it was working fine while on my site at Bluehost.