Help with MySQL

Expand Post »

I am trying to connect to a mysql database. ideally, i'd like it dumped into a grid view so i can edit it... no matter how i try it, i get this error-

Compiler Error Message: BC30002: Type 'ODBCConnection' is not defined.
here is the code for this page:

ASP.NET Syntax (Toggle Plain Text)
<%@ page language="VB" Debug=true %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="Microsoft.Data.Odbc" %>
<HTML>
<HEAD>
<SCRIPT Language="VBScript" Runat="server">
Sub Page_Load(Source as object, e as EventArgs)
Dim sConnection = "DRIVER={MySQL ODBC 3.51 Driver};" _ 
& "SERVER=localhost;" _ 
& "DATABASE=db;" _ 
& "UID=BrowserName;" _ 
& "PWD=bfakepass;" _ 
& "OPTION=3" 
'& 1 + 2 + 8 + 32 + 2048 + 16384 
Dim oConnection as ODBCConnection = new ODBCConnection(sConnection)
Dim sSQL as String = "SELECT FirstName, LastName FROM addresses"
Dim oDataAdapter as ODBCDataAdapter = New ODBCDataAdapter(sSQL, oConnection)
Dim oDataSet as DataSet = new DataSet()
oDataAdapter.Fill(oDataSet)
oDataGrid.DataSource = oDataSet
oDataGrid.DataBind()
End Sub
</SCRIPT >
</HEAD>
<BODY>
<ASP:DataGrid ID="oDataGrid" Runat="server" />
</BODY>
</HTML>
 
<%@ page language="VB" Debug=true %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="Microsoft.Data.Odbc" %>
<HTML>
<HEAD>
<SCRIPT Language="VBScript" Runat="server">
Sub Page_Load(Source as object, e as EventArgs)
Dim sConnection = "DRIVER={MySQL ODBC 3.51 Driver};" _ 
& "SERVER=localhost;" _ 
& "DATABASE=db;" _ 
& "UID=BrowserName;" _ 
& "PWD=bfakepass;" _ 
& "OPTION=3" 
'& 1 + 2 + 8 + 32 + 2048 + 16384 
Dim oConnection as ODBCConnection = new ODBCConnection(sConnection)
Dim sSQL as String = "SELECT FirstName, LastName FROM addresses"
Dim oDataAdapter as ODBCDataAdapter = New ODBCDataAdapter(sSQL, oConnection)
Dim oDataSet as DataSet = new DataSet()
oDataAdapter.Fill(oDataSet)
oDataGrid.DataSource = oDataSet
oDataGrid.DataBind()
End Sub
</SCRIPT >
</HEAD>
<BODY>
<ASP:DataGrid ID="oDataGrid" Runat="server" />
</BODY>
</HTML>

Similar Threads

jsp and mysql in JSP
SQL Server vs MYSQL vs MSQL (i'm stopping now) in MS SQL
MySQL for this forum ... in MySQL
MySQL vs. PostgreSQL in MySQL
MySQL-Front - Graphical Interface for MySQL in MySQL

someoneelse

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

14 posts
since Mar 2007

Permalink

Apr 13th, 2007

Re: Help with MySQL

Did you import namespace System.Data.Odbc?

Btw. You did not declare sConnection as string.

Dim sConnection As String

ManicCW

Reputation Points: 12

Solved Threads: 11

Junior Poster in Training

Offline

95 posts
since Nov 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Run msn messenger on button click in asp.net 2.0

Next Thread in ASP.NET Forum Timeline: Search record from SQLDatabase

DaniWeb Message

Cancel Changes

User Name
Password