Upgrade from 4.0.17 to 5

--0-1961800298-1131682161=:18091
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Dear Sir ,

I need help , there was an error occured in VBScript when I Installed the MySQL 5 , but if I downgrade back to old version 4.0.17 the program run correctly.

The Error message is like this :

Microsoft VBScript runtime error '800a000d'

Is any body know abou this , Please advise. Is the error because VBScript or from MySql ? Thanks.

Rgds,
Eriko


--0-1961800298-1131682161=:18091--

Re: Upgrade from 4.0.17 to 5

--=_alternative 001EA37D852570B6_=
Content-Type: text/plain; charset="US-ASCII"

wrote on 11/10/2005 11:09:21 PM:

> Dear Sir ,
>
> I need help , there was an error occured in VBScript when I
> Installed the MySQL 5 , but if I downgrade back to old version 4.0.
> 17 the program run correctly.
>
> The Error message is like this :
>
> Microsoft VBScript runtime error '800a000d'
>
> Is any body know abou this , Please advise. Is the error because
> VBScript or from MySql ? Thanks.
>
> Rgds,
> Eriko
>

The problem is with neither, most likely. The problem is with the change
of password hashing that occurred in v 4.1 If you don't downgrade the
password hash on the server or upgrade your connection library to use the
new hashing scheme you won't be able to connect.

http://dev.mysql.com/doc/refman/4.1/en/old-client.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 001EA37D852570B6_=--

Re: Upgrade from 4.0.17 to 5

--0-1765561843-1131690955=:25912
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Thanks for reply , i already did changed the password into OLD_PASSWORD. but it's still error occur.

Btw , if I go back to old mysql (WinMySQL as Server / Client ) it's working properly. pls advise. Thanks.

Rgds,
Eriko


SGreen@unimin.com wrote:


wrote on 11/10/2005 11:09:21 PM:

> Dear Sir ,
>
> I need help , there was an error occured in VBScript when I
> Installed the MySQL 5 , but if I downgrade back to old version 4.0.
> 17 the program run correctly.
>
> The Error message is like this :
>
> Microsoft VBScript runtime error '800a000d'
>
> Is any body know abou this , Please advise. Is the error because
> VBScript or from MySql ? Thanks.
>
> Rgds,
> Eriko
>

The problem is with neither, most likely. The problem is with the change of password hashing that occurred in v 4.1 If you don't downgrade the password hash on the server or upgrade your connection library to use the new hashing scheme you won't be able to connect.

http://dev.mysql.com/doc/refman/4.1/en/old-client.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Cheers,
Eriko
--0-1765561843-1131690955=:25912--

Re: Upgrade from 4.0.17 to 5

Check the MySQL manual for upgrade guide, its a long operation that
I've performed a lot here at work, you must notice that there were
major changes from 4.0 to 4.1 and then again to 5.0, so, check for
imcompability and follow the instructions there to upgrade and come
back if anything wrong happens.

Good luck,

On 11/11/05, erikoguard-mysqlwin@yahoo.com
wrote:
> Thanks for reply , i already did changed the password into OLD_PASSWORD. =
but it's still error occur.
>
> Btw , if I go back to old mysql (WinMySQL as Server / Client ) it's worki=
ng properly. pls advise. Thanks.
>
> Rgds,
> Eriko
>
>
> SGreen@unimin.com wrote:
>
>
> wrote on 11/10/2005 11:09:21 PM:
>
> > Dear Sir ,
> >
> > I need help , there was an error occured in VBScript when I
> > Installed the MySQL 5 , but if I downgrade back to old version 4.0.
> > 17 the program run correctly.
> >
> > The Error message is like this :
> >
> > Microsoft VBScript runtime error '800a000d'
> >
> > Is any body know abou this , Please advise. Is the error because
> > VBScript or from MySql ? Thanks.
> >
> > Rgds,
> > Eriko
> >
>
> The problem is with neither, most likely. The problem is with the change =
of password hashing that occurred in v 4.1 If you don't downgrade the pass=
word hash on the server or upgrade your connection library to use the new h=
ashing scheme you won't be able to connect.
>
> http://dev.mysql.com/doc/refman/4.1/en/old-client.html
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> Cheers,
> Eriko
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org