gus
Posts: 1
|
| Posted: 08/21/2007, 7:04 PM |
|
Hi, I'm experiencing some problems trying to access a MySql5 database (publishing-mode) in my project:
Quote :
Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\cchargepub\siciavm\db_mysql.php on line 99
Database error: cannot connect to Database Client does not support authentication protocol requested by server; consider upgrading MySQL client
MySQL Error
Session halted.
I'm using the following software:
-MySql 5.0.45-comunity-nt (publishing or production mode)
-DB MySQL Class @0-476F305F
-SqlServer2000 as a design-mode database
-WindowsXPSp2
-CodeChargeStudio 3.2
I've just purchased CodeChargeStudio 3.2 so I'm a still a newbie.
Cheers,
Gus
|
 |
 |
jpser
Posts: 44
|
| Posted: 08/22/2007, 3:59 AM |
|
I suggest that you update myodbc
If your problem remains : on your development or production server
You have to call yessoftware support
I use CCS since several years
It is a good product BUT
sometimes updates or new releases contain bugs
I think it is the case with ccs 3.2
For instance : mysqli is definitly buggy and the support gave me a patch that is is not included in
normal release
_________________
jp serei
|
|
|
|
DonB
|
| Posted: 08/22/2007, 5:22 AM |
|
The 'mysql client library' component is not current on your machine, or you
migrated an older database to MySQL5. The password handing algorithm
changed around version 4.0 or so.
You need to:
upgrade to the new client library OR
reset the password(s) on your database now that it's V5 OR
use the OLD_PASSWORD() function in MySQL to insert the old-style password
into the V5 database
See the MySQL documentation regarding the usage of OLD_PASSWORD()
--
DonB
http://ccswiki.gotodon.net
"gus" <gus@forum.codecharge> wrote in message
news:546cb99b64f859@news.codecharge.com...
> Hi, I'm experiencing some problems trying to access a MySql5 database
> (publishing-mode) in my project:
>
> Quote :
> Warning: mysql_connect() [function.mysql-connect]: Client does not support
> authentication protocol requested by server; consider upgrading MySQL
client in
> c:\inetpub\wwwroot\cchargepub\siciavm\db_mysql.php on line 99
> Database error: cannot connect to Database Client does not support
> authentication protocol requested by server; consider upgrading MySQL
client
> MySQL Error
> Session halted.
>
>
> I'm using the following software:
> -MySql 5.0.45-comunity-nt (publishing or production mode)
> -DB MySQL Class @0-476F305F
> -SqlServer2000 as a design-mode database
> -WindowsXPSp2
> -CodeChargeStudio 3.2
>
>
> i've just purchased CodeChargeStudio 3.2 so I'm a still a newbie.
>
> Cheers,
>
> Gus
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
jmancera
Posts: 13
|
| Posted: 09/06/2007, 7:18 AM |
|
Hi....
I've been thru the same problem, the only solution is find the odbc dryver for mysql version MySQL ODBC 3.51 Driver DSN further drivers have that problem in windows...
hope works for you
|
|
|
|
|
