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--
erikoguard-mysqlwin [ Fr, 11 November 2005 05:09 ] [ ID #1053548 ]

Re: Upgrade from 4.0.17 to 5

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

<erikoguard-mysqlwin [at] yahoo.com> 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_=--
SGreen [ Fr, 11 November 2005 06:35 ] [ ID #1053551 ]

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 [at] unimin.com wrote:


<erikoguard-mysqlwin [at] yahoo.com> 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--
erikoguard-mysqlwin [ Fr, 11 November 2005 07:35 ] [ ID #1053553 ]

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 [at] yahoo.com
<erikoguard-mysqlwin [at] 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 [at] unimin.com wrote:
>
>
> <erikoguard-mysqlwin [at] yahoo.com> 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 [at] m.gmane.org
Daniel da Veiga [ Fr, 11 November 2005 14:08 ] [ ID #1053554 ]
Datenbanken » gmane.comp.db.mysql.windows » Upgrade from 4.0.17 to 5

Vorheriges Thema: MySQL GUI Client
Nächstes Thema: Embedded mysql and VB - server_init GPF