试试: <SCRIPT LANGUAGE=VBScript RUNAT=Server> Sub Application_OnStart WEB_Connect_Database_link_string="DRIVER={Microsoft ODBC for Oracle};SERVER=服务器计算机名;User Id=testuser;PASSWORD=testpw;" Set Application("WEB_Connect") = Server.CreateObject("ADODB.Connection") Application("WEB_Connect").Open WEB_Connect_Database_link_string End sub </SCRIPT>
我用sqlplus连接服务器ok,而且iis也没有问题
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
WEB_Connect_Database_link_string="DRIVER={Microsoft ODBC for Oracle};SERVER=服务器计算机名;User Id=testuser;PASSWORD=testpw;"
Set Application("WEB_Connect") = Server.CreateObject("ADODB.Connection")
Application("WEB_Connect").Open WEB_Connect_Database_link_string
End sub
</SCRIPT>
谢谢你啦,我试过了,就这种是好使的。
1、Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=timecard;Data Source=bosweb;Extended Properties=""2、Provider=MSDAORA;Password=timecard;User ID=timecard;Data Source=bosweb但asp连接字符串是这样:
Provider=MSDAORA.1;Password=zdwy;User ID=zdwy;Data Source=bosweb;Persist Security Info=Trueasp与asp.net像是有区别
我试过在asp里可以这样连:2、Provider=MSDAORA;Password=timecard;User ID=timecard;Data Source=bosweb
也可以这样连 :Provider=MSDAORA.1;Password=zdwy;User ID=zdwy;Data Source=bosweb;Persist Security Info=True
但是在asp.net里倒是这两个都可以的1、Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=timecard;Data Source=bosweb;Extended Properties=""2、Provider=MSDAORA;Password=timecard;User ID=timecard;Data Source=bosweb
说不定没有什么大区别