举个例子吧!Set Cn = Server.CreateObject("ADODB.connection")
Cn.open "DSN=bgw;UID=test;PWD=test123;"
Set Rs = Server.createObject("ADODB.Recordset")SQLSelect ="Select * from table1 where district='"&district&"' and name='"&name&"'"
set rs = cn.execute(SQLSelect)
Cn.open "DSN=bgw;UID=test;PWD=test123;"
Set Rs = Server.createObject("ADODB.Recordset")SQLSelect ="Select * from table1 where district='"&district&"' and name='"&name&"'"
set rs = cn.execute(SQLSelect)
var sDatabaseStr="Provider=OraOLEDB.Oracle.1;Password=aaa;Persist Security Info=True;User ID=aaa;Data Source=myserver";
var con=Server.CreateObject("adodb.connection");
con.open(sDatabaseStr);
在open 的时候出错:
未找到提供程序。该程序可能未正确安装。
可是我使用vb可以正确连结的
conn.CursorLocation = adUseClient
conn.Open "Provider=MSDAORA.1;" & _
"Password=qsun;User ID=qsun;" & _
"Data Source=manu;"
我是这样做的,试试看!
对应的用户名、口令数据库别名修改。