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
Unsolved 
