使用ORACLE带的ADO驱动试下:
1、Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=timecard;Data Source=bosweb;Extended Properties=""还有
asp通过ado连接oracle:
<%
dim cn,rs,driver_name
driver_name="Provider=MSDAORA.1;Password=pass;User ID=user;Data Source=afis;Persist Security Info=True"
set cn = server.CreateObject("adodb.connection")
cn.open driver_name
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from table",cn,3,1
do while not rs.eof
response.write rs("field")
rs.movenext
loop
%>
1、Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=timecard;Data Source=bosweb;Extended Properties=""还有
asp通过ado连接oracle:
<%
dim cn,rs,driver_name
driver_name="Provider=MSDAORA.1;Password=pass;User ID=user;Data Source=afis;Persist Security Info=True"
set cn = server.CreateObject("adodb.connection")
cn.open driver_name
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from table",cn,3,1
do while not rs.eof
response.write rs("field")
rs.movenext
loop
%>
解决方案 »
- 查询索引?
- 一个有争议的oracle查询优化
- oracle9i导入数据时发生这样的错误,再次百分求助
- oracle 随机取一行记录 的问题
- Oracle 10g如何访问MSSQL数据库中的数据??
- 新手提问:select * into NewTable from OldTable在ORACLE中出错,能实现这功能吗
- timeout while wait to lock object pakage1,什么问题
- 关于建立java存储过程的错误。
- 关于TOAD的问题,菜鸟问,别见笑。
- SQL语句问题--oracle
- access的SQL如何转换为oracle的SQL
- 安装的时候Database Configuration Assistant失败!!!
dim cn,rs,driver_name
driver_name="Provider=MSDAORA.1;Password=pass;User ID=user;Data Source=afis;Persist Security Info=True"
set cn = server.CreateObject("adodb.connection")
cn.open driver_name
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from table",cn,3,1
do while not rs.eof
response.write rs("field")
rs.movenext
loop
%>
重新下载一个驱动吧.估计是你的连接软件有问题
http://otn.oracle.com/software/tech/windows/ole_db/index.html