1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
Dim connexion, DSN, Req, RSTxt
ServerAddress = "localhost" ' Serveur MySQL
DBName = "norditube_site" ' Nom de la Base de données
UID = "Norditube" ' Nom d'utilisateur
Password = "xxxxxx" ' Mot de Passe
DSN = "driver={MySql ODBC 3.51 Driver};server=" & ServerAddress & ";db=" & DBName & ";user id=" & UID & ";pwd=" & Password & ";option=16386"
Set Connexion = Server.CreateObject("ADODB.Connection")
Connexion.ConnectionTimeout = 30
Connexion.CommandTimeo
ReqSQL = "SELECT * From Clients"
Set RS = Server.CreateObject("ADODB.RecordSet")
RS.Open ReqSQL, Connexion, 2, 3
RS.addnew
RS("clisociete") = "Nommmmmmmmm2222"
RS.update
Reponse.write(RS("clinumauto")) |
Partager