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:
<asp:SqlDataSource
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 > [at] ID">
<SelectParameters>
<asp:Parameter Type=3D"int32" Name=3D"ID" />
</SelectParameters>
</asp:SqlDataSource>
I only create a datasource with a select statement, and one parameter
( [at] 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 [at] m.gmane.o rg
