avevo il driver vecchio ma ora l'errore e questo:

ERROR [3D000] [MySQL][ODBC 3.51 Driver][mysqld-3.23.55-nt]No Database Selected

il codice è il seguente:


<%@ Page Language="VB" Debug="true" %>

<%@ Import Namespace="System.Data" %>

<%@ Import NameSpace="Microsoft.Data.Odbc" %>

<html>

<script runat="server">

Public Sub Invia(Sender As Object, E As EventArgs)

Dim strConn As String = ("DRIVER={MySQL ODBC 3.51 Driver};SERVER=192.168.0.210;UID=USERID;pwd:PASSWD ;DATABASE=prova;")


Dim myConnection As New OdbcConnection(strConn)

Dim mySelectQuery As String = "SELECT * FROM conferme"


Dim myCommand As New OdbcCommand(mySelectQuery, myConnection)

myConnection.Open()

Dim myReader As OdbcDataReader

myReader = myCommand.ExecuteReader()

While myReader.Read
Response.Write(myReader.GetString(0)&" - "& myReader.GetString(1)&" - "& myReader.GetValue(2)&" - "& myReader.GetValue(3)&" - "& myReader.GetValue(4)&"
" )
end while
myReader.Close()
myConnection.Close()

End Sub

</script>

<body>
<form runat="server">

<asp:button runat="server" OnClick="Invia" Text="Inizia Ricerca"/>



</form></body></html>
nessun suggerimento....