Hello MySQL,
Backpacker in the foot hills of learning mysql
installed 4.0.4 beta-max-nt on win2k Pro SP3 and using Innodb type
When I connect using MyODBC 3.51 I get the following error.
Run-time error '-2147467259 (80004005)
[MySQL][ODBC 3.51 Driver]Access denied for
user:'[EMAIL PROTECTED]'(Using password: YES)
Note:
If I use * user=rthur and "PWD=" * (User does not exist) code works
In mysql.user there is a row
host=localhost,User=Arthur,Password=fred, All priv set to Y
also Arthur@localhost has global Privileges.
Code
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim strConnectionString As String
strConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=localhost;" & _
"Port=3306;" & _
"socket=MySQL;" & _
"DATABASE=website;" & _
"UID=Arthur;PWD=fred"
Set cnn = New ADODB.Connection
cnn.Open strConnectionString
Set rst = cnn.Execute("select * FROM tblPerson")
--
Best regards,
Arthur mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
