|
蓝森林 http://www.lslnet.com 2006年8月25日 8:28
 求助：ASP与SQL数据库的连接
哪位高手给个语法示例，谢谢！ |
http://do.9jh.com/web123/indexwebdesing.asp?filename=aspdata
这里有 |
| 打不开啊 |
我这里有：
dim conn
dim sql_server
sql_server="127.0.0.1"
set conn=server.createobject("ADODB.CONNECTION")
conn.Open "driver={SQL Server};Server=" & sql_server & ";UID=sa;PWD=;Database=database;" |
SqlDatabaseName = "MyDataBase"
SqlPassword = "Mypsw"
SqlUsername = "Myuid"
SqlLocalName = "127.0.0.1"
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db)
On Error Resume Next
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr |
|
