改写一个ASP测试

来源:百度知道 编辑:UC知道 时间:2024/05/28 05:44:33
有台Linux 配 MYsqlDB,但前台是windows IIS。现在想在IIS里面建个测试页面,但ASP不懂,请大家帮帮忙将下面PHP的语句转成ASP的脚本,谢谢。

<?php
$link=mysql_connect(IP','username','password');
if(!$link) echo "Fail!";
else echo "Success!";
mysql_close();
?>
为什么下面的脚本在IIS页面返回总是"0|链接失败"??????

<%

Function ChkConnection(connectionString)
ON ERROR RESUME NEXT
errDescription = ""
SET conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionTimeout=10
conn.Open connectionString
IF conn.State = 0 THEN
errDescription = "0|链接失败"
ELSE
errDescription = "1|链接成功"
conn.Close
END IF

SET conn = NOTHING
ChkConnection = errDescription
END Function

Response.Write ChkConnection("driver={MySQL};Server=IP;UID=NAME;PWD=password;DATABASE=DB")

%>

<%dim conn,connstr
set conn = server.createobject("adodb.connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=IP;UID=name;PWD=passw;DATABASE=data"
response.write "yes"
On Error Resume Next
response.write "error"
%>

<meta content="text/html",end >
$link=mysql_connect(IP','username','password');
if(!$link) echo "Fail!";
else echo "Success!";
mysql_close();
?>

应该是这样吧