|
| |
Guide connexion de base MySQL en ASP
Command:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON sus.*
TO
'sus_report'
IDENTIFIED BY '*****';
Script ASP:
<%
Set conn_db = Server.CreateObject("ADODB.Connection")
With conn_db
.Provider ="MSDASQL"
.ConnectionString="Driver={MySQL
ODBC 8.0 UNICODE Driver};SERVER=localhost;DATABASE=test_db;UID=login_test;PWD=pass_test;"OPTION=3
.Open
End With
%>
Requete SQL
<%
SQL= "select * from user"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open SQL, conn_db, 3,3
%> |
