How to test a asp connection to mysql?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 20 Oct 2007 23:22 GMT

Have just installed mysql on to my server

Does anyone know of a sample test script that will test if asp can connect
to a test databse?.

I just want to find out if it is working.

thanks

Reply to this Message

Alexey Smirnov - 25 Oct 2007 19:09 GMT

> Have just installed mysql on to my server
>
[quoted text clipped - 4 lines]
>
> thanks

David, I think you're in the wrong group

MySQL.aspx

<%@ Page Language="VB" debug="true" %>
<%@ Import Namespace = "System.Data" %>
<%@ 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 MySqlConnection("server=localhost; user
id=15secs; password=password; database=mydatabase; pooling=false;")

strSQL = "SELECT * FROM mytable;"

myDataAdapter = New MySqlDataAdapter(strSQL, myConnection)
myDataSet = New Dataset()
myDataAdapter.Fill(myDataSet, "mytable")

MySQLDataGrid.DataSource = myDataSet
MySQLDataGrid.DataBind()

End Sub

</script>

<html>
<head>
<title>Simple MySQL Database Query</title>
</head>
<body>

<form runat="server">

<asp:DataGrid id="MySQLDataGrid" runat="server" />

</form>

</body>
</html>

Reply to this Message

David - 25 Oct 2007 20:20 GMT

>> Have just installed mysql on to my server

snip

thank you Alexey

Reply to this Message

How to test a asp connection to mysql?

Free Magazines