Problems with MyODBC and ASP.NET 2.0

Hi,

after creating my asp application (C#) with access as database, I want
to do the final step and use MySQL. But I have strange problems using
the ODBC-Connector.

Here is a small example:

The ASP-Code:

ID=3D"SqlDataSource1"
runat=3D"server"
ConnectionString=3D"DRIVER=3D{MySQL ODBC 3.51
Driver};SERVER=3Dlocalhost;DATABASE=3Dscanner;USER=3Droot;PA SSWORD=3Dmysql;=
OPTION=3D3;"
ProviderName=3D"System.Data.Odbc"
SelectCommand=3D"SELECT Kit_ID FROM
scanner.kit_konfiguration WHERE Kit_ID > @ID">







I only create a datasource with a select statement, and one parameter
(@ID). But when setting the ID within C#, the database only returns 0
rows, here is the C#-Code:

protected void Page_Load(object sender, EventArgs e)
{
SqlDataSource1.SelectParameters["ID"].DefaultValue =3D "0";
}

All this code works fine using access.

Software:
Latest ODBC Connector 3.51.12 and MySQL 4.1.13 on Windows XP Home
Edition SP2 + all updates available.

Could anyone help me?

Regards
Marko

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg