[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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.