[MySQL][MyODBC 5.00.10][MySQL] 1046 No database selected

[MySQL][MyODBC 5.00.10][MySQL] 1046 No database selected

am 23.12.2006 06:08:05 von Awi

------=_NextPart_000_0005_01C7268B.00B4B160
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 =3D "DRIVER=3D{MySQL Connector/ODBC =
v5};server=3DserverName;
uid=3Dusername;pwd=3Dmypassword;database=3DdataBaseName;Opti on=3D3"
=20
Dim Con As ADODB.Connection
Set Con =3D New ADODB.Connection
Con.ConnectionString =3D 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.

------=_NextPart_000_0005_01C7268B.00B4B160--