Can"t connect to MySQL from VS.NET

I am trying to create an ODBC Data Adapter in Visual Studio.NET 2003.

After entering my username/password, which I know are correct, and are
connecting from other apps directly, I get the error,

Access denied for user root@localhost

This is not a permissions error, this is VS.NET screwing around. What is
wrong here?

Thanks
Greg


--
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: Can"t connect to MySQL from VS.NET

Try checkin if the client ODBC library supports the new authentication
format that was introduced in version 4.1. Try this:

1) Enter the mysql server with the user you'll connect from VS, use
the console (command line) client.
2) Set the password using the OLD_PASSWORD function, you should use
the same password, as it will be authenticated OK with new clients (I
believe):

SET PASSWORD=3DOLD_PASSWORD('yourpassword');

3) Exit the client and try VS again.

If that do not work, you should see what is the return from the method
that is connecting and check how VS uses this value to send you the
messages (that is a shot in the dark).

Hope that helps,

On 5/29/05, Greg Quinn wrote:
> I am trying to create an ODBC Data Adapter in Visual Studio.NET 2003.
>=20
> After entering my username/password, which I know are correct, and are
> connecting from other apps directly, I get the error,
>=20
> Access denied for user root@localhost
>=20
> This is not a permissions error, this is VS.NET screwing around. What is
> wrong here?
>=20
> Thanks
> Greg
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

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