MySQL - ASP.NET - Issues....

I'm trying to get started in ASP.NET, but I just don't understand the errors being returned to me. I'm trying to connect to my MySQL database. I have followed several examples from books and the internet with no success. Could someone look at my code and see if I'm screwing something up?

<%@ Import Namespace="System.Data.OleDB" %>
<%@ Import Namespace="System.Data" %>
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="default_page.aspx.vb" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
	<HEAD>
		<%
			'Put user code to initialize the page here
			Dim dr As System.Data.OleDb.OleDbDataReader
			Dim cn As System.Data.OleDb.OleDbConnection
			Dim cmd As System.Data.OleDb.OleDbCommand
			Dim cs As String
			Dim SQL As String

			cs = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
				"DRIVER={MySQL ODBC 3.51 Driver};" & _
				"SERVER=cashwell.no-ip.info;" & _
				"DATABASE=Saphyre;" & _
				"UID=WebTest;" & _
				"Jet OLEDBatabase PASSWORD=asp-net;" & _
				"OPTION=16427"
			cn = New OleDbConnection(cs)
			cn.Open()

			SQL = "SELECT name FROM tbl_hosp;"
			cmd = New OleDbCommand(SQL)
			dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
		%>
		<meta content="Microsoft Visual Studio.NET 7.0" name="GENERATOR">
		<meta content="Visual Basic 7.0" name="CODE_LANGUAGE">
		<meta content="JavaScript" name="vs_defaultClientScript">
		<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
		<meta content="VisualStudio.HTML" name="ProgId">
		<meta content="Microsoft Visual Studio.NET 7.0" name="Originator">
	</HEAD>
	<body MS_POSITIONING="GridLayout">			
		<%	
		Response.Write(dr.GetString(0))
		%>
	</body>
</HTML>

Also, how do you use the ****.vb file? I'm using VS.NET as my editor and if you hit F7 you can go to the ****.vb file, but if I place code in the Page_Load event it never runs..... ????

Any clues?????

Thanks in advance
- Eric

ecashwell

Newbie Poster

22 posts since Aug 2004

Reputation Points: 10

Solved Threads: 0

7 Years Ago

Try changing this line: cmd = New OleDbCommand(SQL) to this: