asp中连接sqlserver的问题---很急,望高手指点 varServerIP = "127.0.0.1:1433"也可以用服务器名字来访问 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 同上,建议你使用服务器的名字.....Server="example1";..........Server="example2";..... varServerIP = "127.0.0.1\实例名" '具体是用\,还是用/,记不太清,你试一下varUserName = "sa"varPassword = "sa"varDataBaseName = "u8m"set my_conn=server.CreateObject ("adodb.connection")myconn= "DRIVER={SQL Server}; Server=" & varServerIP & "; Database=" & varDataBaseName & "; UID=" & varUserName & "; PWD=" & varPasswordmy_conn.open (myconn) varServerIP = "实例名/机器名"varUserName = "sa"varPassword = "sa"varDataBaseName = "u8m"set my_conn=server.CreateObject ("adodb.connection")myconn= "DRIVER={SQL Server}; Server=" & varServerIP & "; Database=" & varDataBaseName & "; UID=" & varUserName & "; PWD=" & varPasswordmy_conn.open (myconn) 写反了是:varServerIP = "机器名\实例名"varUserName = "sa"varPassword = "sa"varDataBaseName = "u8m"set my_conn=server.CreateObject ("adodb.connection")myconn= "DRIVER={SQL Server}; Server=" & varServerIP & "; Database=" & varDataBaseName & "; UID=" & varUserName & "; PWD=" & varPasswordmy_conn.open (myconn) varServerIP = "机器名\实例名"varUserName = "sa"varPassword = "sa"varDataBaseName = "u8m"set my_conn=server.CreateObject ("adodb.connection")myconn= "DRIVER={SQL Server}; Server=" & varServerIP & "; Database=" & varDataBaseName & "; UID=" & varUserName & "; PWD=" & varPasswordmy_conn.open (myconn) 谢谢各位,用 zjcxc的方法搞定了. 请问全局临时表(eg.##aaa) 在系统表中中哪里有记录? 求一sql语句,不难的问题,以前做过,忘记了。 附加数据库报错误823。。。。。 很实用的问题,在网上却找不到解决办法,难道还有更好的方法??? 数据库被破坏,如何提取数据(急) 帮忙 在下初学,请各位不要见笑!请问什么是unicode数据类型?(无内容) 请问Select语句怎么写??急用,谢谢!! 请教:有关SYBASE SQL SERVER中日志清除的问题 sql2005内存持续增长不释放 再问:SQL SERVER中如何实现将一条记录导出成字符串赋值给一个字符串变量,各个字段之间用逗号分开? 如何在触发器中调用外部程序?
.....Server="example1";.....
.....Server="example2";.....
varUserName = "sa"
varPassword = "sa"
varDataBaseName = "u8m"
set my_conn=server.CreateObject ("adodb.connection")
myconn= "DRIVER={SQL Server}; Server=" & varServerIP & "; Database=" & varDataBaseName & "; UID=" & varUserName & "; PWD=" & varPassword
my_conn.open (myconn)
varUserName = "sa"
varPassword = "sa"
varDataBaseName = "u8m"
set my_conn=server.CreateObject ("adodb.connection")
myconn= "DRIVER={SQL Server}; Server=" & varServerIP & "; Database=" & varDataBaseName & "; UID=" & varUserName & "; PWD=" & varPassword
my_conn.open (myconn)
varUserName = "sa"
varPassword = "sa"
varDataBaseName = "u8m"
set my_conn=server.CreateObject ("adodb.connection")
myconn= "DRIVER={SQL Server}; Server=" & varServerIP & "; Database=" & varDataBaseName & "; UID=" & varUserName & "; PWD=" & varPassword
my_conn.open (myconn)
varUserName = "sa"
varPassword = "sa"
varDataBaseName = "u8m"
set my_conn=server.CreateObject ("adodb.connection")
myconn= "DRIVER={SQL Server}; Server=" & varServerIP & "; Database=" & varDataBaseName & "; UID=" & varUserName & "; PWD=" & varPassword
my_conn.open (myconn)