关于ASP语法..（ADO）

本文介绍了关于ASP语法..（ADO）的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 真正的Sever：Window Server 2003，DB Oracle 9i 本地服务器：Window7 64位，DB Oracle 11g客户端32位 -------------------------------------------- - ##真正的Sever来源。 -------------------------- -------------------- real Sever : Window Server 2003 , DB Oracle 9ilocal Server : Window7 64bit , DB Oracle 11g client 32bit----------------------------------------------## real Sever Source.----------------------------------------------Set Conn=Server.CreateObject("ADODB.Connection") Conn.open "Provider=MSDAORA.1;Data Source=CS_TEST.world;User Id=trnusr;Password=trnusr0515" SQL = "Select store_cd, store_kor_nm from MSTADM.CSMST09TB" Set Rs = Server.CreateObject("ADODB.Recordset"") set rs = createobject("adodb.recordset"") set rsCmd = createobject("adodb.Command"") set rsCODE = createobject("adodb.Parameter"") rsCmd.ActiveConnection = conn.connectionstring <==== here!!!! rsCmd.CommandType = 1 rsCmd.CommandText = SQL set rs = rsCmd.execute set rsCmd = nothing set rsCODE = nothing If conn.errors.count = 0 Then Response.Write("OK")else Response.Write(conn.errors(0).description) Response.Write(conn.connectionstring) End If -------------------------------------- ---------------------------- ##到本地服务器 - -------------------------------------------------- --------------- rsCmd.ActiveConnection = conn.connectionstring =>不工作 rsCmd.ActiveConnection = conn =>工作 有什么问题？ 我希望解决方案，请!! 谢谢!! ------------------------------------------------------------------## To local server------------------------------------------------------------------rsCmd.ActiveConnection = conn.connectionstring => not workingrsCmd.ActiveConnection = conn => workingwhat's problem?I hope the solution, please!!Thank you!!推荐答案 引用：我想创造环境开发。 所以从Real-Sever Source复制到本地电脑。 但是来源不能在本地电脑工作。 => ; rsCmd.ActiveConnection = conn.connectionstring（原创） 我修好了。 （rsCmd.ActiveConnection = conn） 然后它正在工作。 我想知道原因。I want to make environment for development.So Copy to local pc from Real-Sever Source.But The Source is not working at local pc.=> rsCmd.ActiveConnection = conn.connectionstring (Original) Sot I repaired it. ( rsCmd.ActiveConnection = conn )And then it's working. I want to know the reason. Refer - ActiveConnection Property（ADO）。 ActiveConnection 接受 Connection 对象，而不是字符串。由于 conn.connectionstring 是一个字符串，所以它不起作用。它适用于conn，因为它是 Connection Object。Refer - ActiveConnection Property (ADO). ActiveConnection takes a Connection object, not a string. As conn.connectionstring is a string, so it does not work. It worked with conn, because it is a Connection Object. 这篇关于关于ASP语法..（ADO）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！