MySQL ODBC 3.51 Driver and Visual Basic 6.0
- From: rll <rll@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 28 Nov 2006 19:01:00 -0800
I have Windows XP Professional and Visual Basic 6.0. I just installed MySQL
5.0 and MySQL ODBC 3.51. And I used the MySQL Server Instance Config Wizard
to create an ananymous account. However, when I run my VB6 procedure as
follows:
Private Cnt As New ADODB.Connection
Cnt.Open _
"DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=localhost;" & _
"DATABASE=Test;"
I get the message: [MySQL][ODBC 3.51 Driver] Access denied for user
'ODBC'@'localhost' (using password: NO)
Can someone please tell me where I went wrong with the setup? I'm the only
one using my computer so I don't need security with user names and passwords.
Thanks - Ron
.
- Follow-Ups:
- Re: MySQL ODBC 3.51 Driver and Visual Basic 6.0
- From: Frank Hickman [MVP]
- Re: MySQL ODBC 3.51 Driver and Visual Basic 6.0
- Next by Date: Re: How can I automate an odbc connection
- Next by thread: Re: MySQL ODBC 3.51 Driver and Visual Basic 6.0
- Index(es):