I'm going to assume you are using .NET 1.1 on this. When you unzipped
the mysql-connector-net package you must either install the
MySQL.Data.dll to the GAC, or copy it to the bin folder under the
directory you are working on in your web application. These
requirements are not specific to this connector, but rather for the
entire .NET Platform.
Please let us know if you have any other problems in this matter.
Anthony Liu wrote:
>Hi, I was not able to install the MySQL.Data.msi
>connector for .net. I got a 2908 error message. Then
>I downloaded the no-installer version with file name
>"mysql-connector-net-1.0.6-noinstall.zip" and unzipped
>to my hard drive.
>In my aspx page, I have this:
><%@ Import Namespace = "MySql.Data.MySqlClient" %>
><script language="VB" runat="server">
>Sub Page_Load(sender As Object, e As EventArgs)
> Dim myConnection As MySqlConnection
> Dim myDataAdapter As MySqlDataAdapter
> Dim myDataSet As DataSet
> Dim strSQL As String
> Dim iRecordCount As Integer
> myConnection = New
> strSQL = "SELECT * FROM testtable;"
> myDataAdapter = New MySqlDataAdapter(strSQL,
> myDataSet = New Dataset()
> myDataAdapter.Fill(myDataSet, "testtable")
> MySQLDataGrid.DataSource = myDataSet
>I get the following error message:
>BC30002: Type 'MySqlConnection' is not defined.
>Apparently, somehow, I have to register the .net
>connector with web server. The documentation never
>tells us how to do it. In other words, the .net
>connector package was unzipped to
>C:\mysql_net_connector, but how does my web
>application know where it is?
>I tried the 3.51 ODBC driver, too, but got the same
>I keep searching google and mysql mailing list, but
>could not find very helpful information. I am at my
>wits end. Could anyone give me a hint?
>Yahoo! Mail - PC Magazine Editors' Choice 2005