[MySQL][MyODBC 5.00.10][MySQL] 1046 No database selected
"Awi" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <000801c72650$5991b930$6b6464c0@awi> |
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.