<%@ language="javascript" codepage="1252" %>
<%
// ----------------------------------------------------------------------------
// -- $Id: myodbc_catastrophic_failure1.asp 5232 2005-06-27 09:45:59Z wpc0756\Emmanuel $
// ----------------------------------------------------------------------------
%>
<%
// Create a connection to local MyODBC
var strDatabase = "testmyodbc";
var strConnectionString = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=" + strDatabase + ";Option=2;User ID=testmyodbc;Password=testmyodbc;";
var objConnection = Server.CreateObject("ADODB.Connection");
objConnection.Open(strConnectionString);
%>
Connection successful.
<%
var objRecordset = objConnection.Execute("SELECT * FROM testmyodbc.myodbc_catastrophic_failure;");
%>
SELECT Done - objRecordset.EOF = <%=objRecordset.EOF%>
<%
// Store connection
Session("MYSQL_CONNECTION") = objConnection;
%>
ADODB.Connection object has been saved in IIS Session.
- Please restart MySQL (
NET STOP MySQL & NET START MySQL)
- Click on "GO!" button below