Authentication Errors

Hi, heres the background:

Running on XP Pro SP1, IIS, MySQL 4.1 and MyODBC 3.51

ASP script:

<%
dim adoConn
dim adoRS
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.CursorLocation = 3 'adUseClient
adoConn.Open "DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=mysql;UID=root;PWD=123456;
OPTION=16427"
adoRS.ActiveConnection = adoConn
if adoConn.errors.count = 0 then
adoRS.Open "Select ...", adoConn
......
adoRS.Close
else
response.write ("ERROR: Couldn't connect to database")
end if

adoConn.Close
Set adoRS = nothing
Set adoConn = nothing
%>


User table:
+-----------+------+---------------------------------------- ---+-------------+--
-----------+-------------+-------------+-------------+------ -----+-------------+
---------------+--------------+-----------+------------+---- -------------+------
------+------------+--------------+------------+------------ -----------+--------
----------+--------------+-----------------+---------------- --+----------+------
------+-------------+--------------+---------------+-------- -----+--------------
---+
| Host | User | Password | Select_priv | I
nsert_priv | Update_priv | Delete_priv | Create_priv |
Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv
| References_priv | Index
_priv | Alter_priv | Show_db_priv | Super_priv |
Create_tmp_table_priv | Lock_ta
bles_priv | Execute_priv | Repl_slave_priv |
Repl_client_priv | ssl_type | ssl_c
ipher | x509_issuer | x509_subject | max_questions |
max_updates | max_connectio
ns |
+-----------+------+---------------------------------------- ---+-------------+--
-----------+-------------+-------------+-------------+------ -----+-------------+
---------------+--------------+-----------+------------+---- -------------+------
------+------------+--------------+------------+------------ -----------+--------
----------+--------------+-----------------+---------------- --+----------+------
------+-------------+--------------+---------------+-------- -----+--------------
---+
| localhost | root |
*B16D3E15B6C1F4D7D9173FFAB1327A11947FF84D | Y | Y
| Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y
| Y | Y | Y | |
| | | 0 | 0 |
0 |
| localhost | www |
*B16D3E15B6C1F4D7D9173FFAB1327A11947FF84D | Y | Y
| Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y
| Y | Y | Y | |
| | | 0 | 0 |
0 |
| % | root | *B16D3E15B6C1F4D7D9173FFAB1327A11947FF84D
| Y | Y
| Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y
| Y | Y | Y | |
| | | 0 | 0 |
0 |
| % | www | *B16D3E15B6C1F4D7D9173FFAB1327A11947FF84D
| Y | Y
| Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y
| Y | Y | Y | |
| | | 0 | 0 |
0 |
+-----------+------+---------------------------------------- ---+-------------+--
-----------+-------------+-------------+-------------+------ -----+-------------+
---------------+--------------+-----------+------------+---- -------------+------
------+------------+--------------+------------+------------ -----------+--------
----------+--------------+-----------------+---------------- --+----------+------
------+-------------+--------------+---------------+-------- -----+--------------
---+

When running the script, I get prompted to enter
username and password. 3x then fails.

If I run mysql from the bin directory at the command
prompt, without specifing -u and -p options, I get:

ERROR 1045 (28000): Access denied for user
'ODBC'@'localhost' (using password: N
O)

I have used this combination before, but have been out
of the programming scene for about a year. I dont know
if it is the platform I am on, the compatibility
between the ODBC and SQL version or what, but it is
driving me insane. I can connect using the DBTools
application no problem.

Any words of advise?

Thanks,

Keith Clark
kclark6595@yahoo.com


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.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