ASPµ÷ÓÃORACLEº¯ÊýµÄÎÊÌâ
º¯ÊýµÄ°üÍ·ÈçÏÂ.
create or replace package ITOSC_ACCESS IS
FUNCTION CALLSERVICE(SerialNo varchar2,inValue in out nocopy varchar2,outValue out sys_refcursor,hint out nocopy varchar2,error out nocopy varchar2) return pls_integer
ASPµ÷ÓõĴúÂëÈçÏÂ:
const connstr_xcjg="Provider=OraOLEDB.Oracle;Password=call0901;User ID=service;Data Source=dss;Persist Security Info=True"
dim cn
dim rs
dim cm
dim XmlHtml
dim syr
dim sfzmhm
set cn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
set cm=server.CreateObject("adodb.command")
cn.ConnectionString = connstr_xcjg
cn.open
Set cm.ActiveConnection = cn
cm.CommandType = 1
cm.commandtext = "{? = Call itosc_access.callservice(?,?,?,?)}"
cm.Parameters.Append cm.CreateParameter("l_request",3,4)
cm.Parameters.Append cm.CreateParameter("SerialNo",200,1,256,"1234567891")
cm.Parameters.Append cm.CreateParameter("inValue",200,1,256,",02,B6E228,")
cm.Parameters.Append cm.CreateParameter("hint",200,2,256)
cm.Parameters.Append cm.CreateParameter("error",200,2,256)
set rs = cm.Execute()
cn.close
´íÎóÐÅÏ¢:wrong number or t
Ïà¹ØÎÊ´ð£º
conn.asp
<%
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.MapPath("Connt ......
<%On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.begintrans
conn.Open ("Driver={SQL Server};server=(local);uid=sa;database=student;pwd=")
......
ÎÒµÄ網頁´ú碼為ASP語ÑÔ,驗證·½Ê½為ϵ統×Ô帶µÄWINDOW驗證ģʽ.
現ÔÚÎÒÈç¹ûÒªÔÚASP´ú碼ÖÐ獲È¡當ǰµÄµÇÈëÈË ......
ÎÒ°ïѧУ×öÁËÒ»¸öÕ¾£®
ÔÚÐ£Ô°ÍøµÄÇé¿öÏ£¬Äܹ»µÇ½³É¹¦£¬ºǫ́ÕʺŶ¼ÄÜͨ¹ý£¬½øÈëºǫ́
µ«ÊÇÔÚÍâÍø£Á£ÄµÄÇé¿öÏ£¬Äܹ»µÇ½ºǫ́µÄÒ³Ãæ£¬Ò³ÃæÊÇ£Á£Ó£ÐÎļþ£®
µ«ÊÇÊäÈëÕʺźÍÃÜÂëµÄʱºò£¬ÍøÒ³ÔËÐкܾö¼ ......
Ò»¶Îʱ¼äºó ¾Í²»ÄÜÓõÄÄÇÖÖ
¿ÉÒÔÓÃ×é¼þдÂð?
×é¼þ ÊDz»ÊDZØÐëÏÈÔÚ·þÎñÆ÷°²×° ²ÅÄÜʹÓÃ?
ÄÇÓÃÐéÄâÖ÷»úµÄ ²»¾ÍûϷÁË....
ewebeditor¾ÍÊÇҪע²á²ÅÄÜÓõÄ
Ã²ËÆÊÇûɶÓõ ......