catastrophic failure

I am running MySQL 4.1.10. When trying to use MySQL ODBC 3.51 Driver and
VB6.0 i get a catastophic failure using:

Set conn = New ADODB.Connection
conn.CursorLocation = adUseClient
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=localhost;" _
& "DATABASE=time_schedule;" _
& "UID=Myself;" _
& "PWD=password;"
conn.Open

Anything obvious here? It all worked fine using 4.0.20.


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.5.0 - Release Date: 2/25/2005


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

Re: catastrophic failure

Upgrade to 4.0.11 and it should go away.

Mike


Mark Ogles wrote:
> I am running MySQL 4.1.10. When trying to use MySQL ODBC 3.51 Driver and
> VB6.0 i get a catastophic failure using:
>
> Set conn = New ADODB.Connection
> conn.CursorLocation = adUseClient
> conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
> & "SERVER=localhost;" _
> & "DATABASE=time_schedule;" _
> & "UID=Myself;" _
> & "PWD=password;"
> conn.Open
>
> Anything obvious here? It all worked fine using 4.0.20.
>
>

--
Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535
Mobile: +1 403-330-0870

MySQL User Conference (Santa Clara CA, 18-21 April 2005)
Early registration until February 28: www.mysqluc.com

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

Re: catastrophic failure

I am assuming you are continuing to use the same databases/tables from=
4.0.20. If so, then you have to fix your mysql user table since the=
password authentication changed, run with using old_passwords option or=
reset all of the user passwords.

These pages discusses this problem -=
http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html and=
http://dev.mysql.com/doc/mysql/en/old-client.html .

Cheers,

Marcel

*********** REPLY SEPARATOR ***********

On 26/02/2005 at 18:08 Mark Ogles wrote:

>I am running MySQL 4.1.10. When trying to use MySQL ODBC 3.51 Driver and
>VB6.0 i get a catastophic failure using:
>
>Set conn =3D New ADODB.Connection
> conn.CursorLocation =3D adUseClient
> conn.ConnectionString =3D "DRIVER=3D{MySQL ODBC 3.51 Driver};" _
> & "SERVER=3Dlocalhost;" _
> & "DATABASE=3Dtime_schedule;" _
> & "UID=3DMyself;" _
> & "PWD=3Dpassword;"
> conn.Open
>
>Anything obvious here? It all worked fine using 4.0.20.
>
>
>--
>No virus found in this outgoing message.
>Checked by AVG Anti-Virus.
>Version: 7.0.300 / Virus Database: 266.5.0 - Release Date: 2/25/2005
>
>
>--
>MySQL Windows Mailing List
>For list archives: http://lists.mysql.com/win32
>To unsubscribe:=
http://lists.mysql.com/win32?unsub=3Dlmforget2@rogers.com


Marcel


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