asked on Create Global.asa for MySql
Hi :
I am creating the global.asa file to mysql as follows:
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Session_OnStart()
Session("ConnectionString"
End Sub
Sub Session_OnEnd()
End Sub
</SCRIPT>
but the time to prove it in asp:
<%
dim conn
conn = Session("ConnectionString"
Response.Write(conn)
Response.End
%>
seems that the global.asa file did not run because I fail to get the connection string ..
as I create? and check it out?
thanks
I am creating the global.asa file to mysql as follows:
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Session_OnStart()
Session("ConnectionString"
End Sub
Sub Session_OnEnd()
End Sub
</SCRIPT>
but the time to prove it in asp:
<%
dim conn
conn = Session("ConnectionString"
Response.Write(conn)
Response.End
%>
seems that the global.asa file did not run because I fail to get the connection string ..
as I create? and check it out?
thanks
ASPMySQL Server
Last Comment
LimonKavas
Here is a link for the ODBC setup - http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-dsn-windows.html
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks for the answer ...
I needed to leave the global.asa in the root directory, it had within the home directory of my future application.
I finally did so:
I needed to leave the global.asa in the root directory, it had within the home directory of my future application.
I finally did so:
sub Application_OnStart
Application("ConnectionString") = "Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=1111;Uid=222222;Pwd=33333"
end sub
------------------ 00000 -----------
set ConexionLW = Server.CreateObject("ADODB.Connection")
ConexionLW.Open Application("ConnectionString")
SQL = "Select * From usuario"
Set RS = ConexionLW.Execute(SQL)
global.asa in root directory.
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Session_OnStart
Session("ConnectionString"
End Sub
</SCRIPT>
For MY SQL you need to have an ODBC System DSN configured.
driver={MySQL ODBC 3.51 Driver};server=<SERVER>;da
Let us know,
Cheers,
Hades666