 | | | 1046 No database selected | 1046 No database selected 2006-12-25 - By Awi
Back
I use VB and MySQL Server 5.0
when i use MySQL ODBC 3.51 Driver as connector, there was no problem.
then i try to use MySQL Connector/ODBC 5.00.10 beta
there was an error
"[MySQL][MyODBC 5.00.10][MySQL] 1046 No database selected"
when i run this query
"select * from table_name order by field_name"
i make connection like this
conString = "DRIVER={MySQL Connector/ODBC v5};server=serverName;
uid=username;pwd=mypassword;database=dataBaseName;Option=3"
Dim Con As ADODB.Connection
Set Con = New ADODB.Connection
Con.ConnectionString = conString
Con.Open
there was no problem for this connection
when i try to use with DSN, the error still appear
Thanx for the answer.
|
|
|