能提前看到返利多少:ASP 页面中如何连接远程SQL SERVER2000?
来源:百度文库 编辑:高考问答 时间:2024/05/17 00:49:51
<%
conndata="driver={SQL Server};server=(61.147.37.56);uid=#%8c_scadata88;pwd=123456;database=#%8c_scadata88"
conttstr="SQL"
Set Conn = Server.CreateObject ("ADODB.Connection")
Conn.open "driver={SQL Server};NETWORK=DBMSSOCN;server=(61.147.37.56);uid=#%8c_scadata88;pwd=123456;database=#%8c_scadata88"
%>
怎么接连不了??
conndata="driver={SQL Server};server=(61.147.37.56);uid=#%8c_scadata88;pwd=123456;database=#%8c_scadata88"
conttstr="SQL"
Set Conn = Server.CreateObject ("ADODB.Connection")
Conn.open "driver={SQL Server};NETWORK=DBMSSOCN;server=(61.147.37.56);uid=#%8c_scadata88;pwd=123456;database=#%8c_scadata88"
%>
怎么接连不了??
Dim StrServer,StrUid,StrSaPwd,StrDbName
StrServer="61.139.126.70"
StrUid="sa"
StrSaPwd="123456"
StrDbName="db"
Dim Conn
Dim StrDSN
StrDSN="driver={SQL server};server="&StrServer&";uid="&StrUid&";pwd="&StrSaPwd&";database="&StrDbName
set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open StrDSN
//我这个是经常用的,你试试
如果还是不行,在企业管理器中“注册服务器”试一下,看是网络的原因还是帐号的原因