时间: 2021-07-31 作者:daque
体例情况: 1、操纵体例:windows 20002、数据库: oracle 8i r2 (8.1.6) for nt 企业版3、安置路途:c:\oracle考察本领: 1、连入sql*plus以system/manager用户登录,sql> conn system/manager创造新的用户:如user1/pass1,付与connect,resource权力。sql> grant connect,resource to user1 identified by pass1;sql> conn user1/pass1sql> create table test(a date);oracle数据库的范例名,本例:oradboracle用户名,本例:user1oracle长机字符串:oradbtnsnames.ora文献中oradb = (description = (address_list = (address = (protocol = tcp)(host = 192.1.1.1)(port = 1521)) ) (connect_data = (service_name = oradb) ) )2、在iis默许www目次下创造test.asp,用notebook编纂,输出以次代码<%set conn=server.createobject("adodb.connection")dns="provider=oraoledb.oracle.1;persist security info=true;user id=user1;password=pass1;data source=oradb"conn.open dnssql="insert into test(a) values(sysdate)"set rs=conn.execute(sql)set rs=nothingconn.closeset conn=nothing%><%set conn=server.createobject("adodb.connection")dns="provider=oraoledb.oracle.1;persist security info=true;user id=user1;password=pass1;data source=oradb"conn.open dnssql="select to_char(a,'hh24:mi:ss') from test"set rs=conn.execute(sql)do while (not rs.eof)%><table border=1><tr><td><%=rs.fields(0).value%></font></td></tr><%rs.movenextlooprs.closeset rs=nothingconn.closeset conn=nothing%>3、翻开一个欣赏器窗口,输出以次地方来察看运转截止,不妨经过连接的按f5键来革新表露截止http://localhost/test.asp归纳: 运用之上代码,不妨省去创造odbc的烦恼,并普及功效。