hp server support

ASP Classic database connection file support Access,mssql server Dim conn,connstring Sub openconn () if db_type = "Access" Then connstring = "Provider = Microsoft.jet.oledb.4.0;data Source =" Server.MapPath (Accpath) els EIf Db_type = "SQL" Then connstring = "Provider = SQLOLEDB; User ID = " Sqlusername "; Password = " SQLPassword "; Initial Catalog = " Sqldatabasename "; Data Source = " Sqlsource ";

Tags: dex lin https use keyword window prot art query1 Enter mysql-uroot-p in the command window first via cmd into MySQL2 Changing the encryption methodmysql>ALTERUSER‘root‘@‘localhost‘IDENTIFIEDBY‘password‘PASSWORD EXPIRE NEVER;Query OK, 0rowsaffected (0.10 sec)3 Changing your passwordmysql>ALTERUSER‘root‘@‘localhost‘IDENTIFIEDWITHmysql_native_passwordBY‘123‘;Query OK, 0rowsaffected (0.35 sec)This password is navicat link mysql password 4 refreshmysql> FLUSHPRIVILEGES;Query OK, 0rowsaffected (

Place the D:\wamp\bin\php\php5.5.12\ext path under theThese two files are copied to php.iniLink Database methods$serverName= "."; $connectionInfo=Array("Database" = "Yunjianyan", "UID" = "sa", "PWD" = "123"); $conn= Sqlsrv_connect ($serverName,$connectionInfo ); if($conn===false ) { die(Print_r(Sqlsrv_errors (),true)); } $sql= "SELECT * from Users"; $stmt= Sqlsrv_query ($conn,$sql ); if($stmt===false) { die(Print_r(Sqlsrv_errors (),true) ); } while($row= Sqlsrv_fetch_array ($stmt)) { Echo