mssql 数据库连接，连不上。要怎么弄

xiaobeer

MM_conn_STRING_own = "Driver={SQL Server};server=##.db.2856595.hostedresource.com;uid=##;pwd=##;database=##;"
Set conn = Server.Createobject("ADODB.Connection")
conn.open MM_conn_STRING_own
Set Rs = Server.CreateObject("ADODB.RecordSet")
Rs.Open "select * from adminLogin where admin='"&admin&"' and password='"&password&"' " ,conn,1,1

数据库连接，这样应该没有错啊。但连不上数据库。

fourix

你是从GD空间运行的网站吗，还是从别的空间链接GD数据库？从别处过来的话，创建数据库时要选择允许外部连接。

xiaobeer

网站就是在godaddy主机上的，我是在本主机创建的mssql数据库的

add.c

登陆数据库管理正常吗?

xiaobeer

管理都正常，也可以操作表。但就是连不上数据库。 这样写连接数据库代码应该没有错吧

add.c

这个是使用asp/ado连接数据库的例子你看看
如果连接不上,建议你把错误提示发给GoDaddy,让他们检查
<%

'Sample Database Connection Syntax for ASP and SQL Server.

Dim oConn, oRs
Dim qry, connectstr
Dim db_name, db_username, db_userpassword
Dim db_server

db_server = "whsql01.mesa1.secureserver.net"
db_name = "your_dbname"
db_username = "your_dbusername"
db_userpassword = "your_dbpassword"
fieldname = "your_field"
tablename = "your_table"

connectstr = "Driver={SQL Server};SERVER=" & db_server & ";Data WidgetsBASE=" & db_name & ";UID=" & db_username & "WD=" & db_userpassword

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open connectstr

qry = "SELECT * FROM " & tablename

Set oRS = oConn.Execute(qry)

Do until oRs.EOF
   Response.Write ucase(fieldname) & ": " & oRs.Fields(fieldname)
   oRS.MoveNext
Loop
oRs.Close


Set oRs = nothing
Set oConn = nothing

%>