28,409
社区成员
发帖
与我相关
我的任务
分享asp连接oracle的问题
连接文件
set conn=server.createobject("adodb.connection")
StrSQL="Provider=OraOLEDB.Oracle.1;Password=system;Persist Security Info=True;User ID=system;Data Source=gztf"
conn.open strsql
出现提示
ADODB.Connection (0x800A0E7A)
未找到提供程序。该程序可能未正确安装。
但是我已经装了啊。
...全文
请发表友善的回复…
发表回复
arlen_zhang 2009-08-18
- 打赏
- 举报
<html>
<body>
<input type="button" language="jscript" onclick="donew();" value="new">
<input type="button" language="jscript" onclick="doedit();" value="edit">
<br>
<label for="cns">connection string:</label><br>
<textarea id="cns" cols="50" rows="5" wrap="soft">
</textarea>
</body>
</html>
<script language="jscript">
/*====================================
AUTHOR: Lux21
====================================*/
var obj_dl;
obj_dl = new ActiveXObject("datalinks");
function donew()
{
var obj_cn;
obj_cn = obj_dl.PromptNew();
if (obj_cn != null)
{
cns.innerText = obj_cn.ConnectionString;
}
}
function doedit()
{
var obj_cn;
obj_cn = new ActiveXObject("adodb.connection");
obj_cn.ConnectionString = cns.innerText;
if (obj_dl.PromptEdit(obj_cn))
{
cns.innerText = obj_cn.ConnectionString;
}
}
</script>
我用这个里面的测试连接时又是成功
<body>
<input type="button" language="jscript" onclick="donew();" value="new">
<input type="button" language="jscript" onclick="doedit();" value="edit">
<br>
<label for="cns">connection string:</label><br>
<textarea id="cns" cols="50" rows="5" wrap="soft">
</textarea>
</body>
</html>
<script language="jscript">
/*====================================
AUTHOR: Lux21
====================================*/
var obj_dl;
obj_dl = new ActiveXObject("datalinks");
function donew()
{
var obj_cn;
obj_cn = obj_dl.PromptNew();
if (obj_cn != null)
{
cns.innerText = obj_cn.ConnectionString;
}
}
function doedit()
{
var obj_cn;
obj_cn = new ActiveXObject("adodb.connection");
obj_cn.ConnectionString = cns.innerText;
if (obj_dl.PromptEdit(obj_cn))
{
cns.innerText = obj_cn.ConnectionString;
}
}
</script>
我用这个里面的测试连接时又是成功
arlen_zhang 2009-08-18
- 打赏
- 举报
还是一样的
ADODB.Connection (0x800A0E7A)
未找到提供程序。该程序可能未正确安装。
/3.asp, 第 4 行
set conn=server.createobject("adodb.connection")
StrSQL="Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort)))(CONNECT_DATA=(SID=MyOracleSID)(SERVER=DEDICATED)));User Id=myUsername;Password=myPassword;"
conn.open strsql
ADODB.Connection (0x800A0E7A)
未找到提供程序。该程序可能未正确安装。
/3.asp, 第 4 行
set conn=server.createobject("adodb.connection")
StrSQL="Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort)))(CONNECT_DATA=(SID=MyOracleSID)(SERVER=DEDICATED)));User Id=myUsername;Password=myPassword;"
conn.open strsql
hookee 2009-08-18
- 打赏
- 举报
用TNS-less的试试看
sql = "Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort)))(CONNECT_DATA=(SID=MyOracleSID)(SERVER=DEDICATED)));User Id=myUsername;Password=myPassword;"
sql = "Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort)))(CONNECT_DATA=(SID=MyOracleSID)(SERVER=DEDICATED)));User Id=myUsername;Password=myPassword;"
