myOdbc mySQL NT VB.net & WinSQL
Posted on 2002-04-12
I want to use mySQL for the data source for a vb .net
project I am doing. I set up mySQL & myODBC on D:\
where I have WinNT 2000 (dual booted with 98 on C:).
Using the mySQL tools I can create databases, tables all of that stuff. But I don't seem to be able to connect with a SQL editor I use, which makes me wonder if I can connect with VB. The error is:
SQL Error State:S1000, Native Error Code: 415, ODBC Error: [TCX][MyODBC]Access denied for user:
'johnsayre@johnnt2000' (Using password: YES)
my.ini looks like this:
#This File was made using the WinMySQLAdmin 1.4 Tool
#4/11/2002 11:02:38 AM
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
#language=D:/mySQL/share/your language directory
#slow query log#=
other config stuff:
Local Host Name
Local User Name
Windows 2000 Service Pack 2
Local IP Address
But all of the server info stuff is blank, as if it is not running.
What do I need to do?