ASP中OracleInProcServer.XOraSession,OraSession怎么总是丢失?

[zyhowe]

<OBJECT RUNAT=Server SCOPE=Application ID=OraSession PROGID="OracleInProcServer.XOraSession"></OBJECT>
<SCRIPT LANGUAGE="VBScript" RUNAT="Server">

'This file contains functions that are executed at the sturtup and
' shutdown of the web server and at the beginning and end of a user session.

'In Application_OnStart subroutine, we initialize a connection pool that will
' be used throughout the web site to connect to the Oracle database.
' Connection pools are particularly suited for web sites that must both provide
' dynamic content from a database and support large concurrent user populations.
' Connection pooling allows the web site to perform faster.

Sub Application_OnStart

'Create a pool of Oracle DBs. Initsize=20, maxsize=100, timeout=600 (in secs),
' alias name = testalias, Username/Password = scott/tiger (The user should note
' that the alias name must already have been created using Oracle Net8 Easy Config
' tool.)

OraSession.CreateDatabasePool 20, 100, 600, "oracle9", "aaa/bbb", 0
'OraSession.CreateDatabasePool 20, 100, 600, "oracle8", "aaa/bbb", 0
End Sub
</SCRIPT>

Oracle8是正常的,Oracle9的ORASESSION怎么总是丢失?

[zyhowe]

up

[zyhowe]

急啊,没人知道吗?

[zyhowe]

每天UP一次,直到...为止

[子陌红尘]

UP

[aceplus]

这个应该是ORACLE的bug吧~

去他们的官方站点上看有没有patch下载

[zyhowe]

Oracle说是MS的问题,MS说是Oracle的问题
TNND

[aceplus]

MS的驱动不太"好",最好用ORACLDE自己的驱动，不过是JDBC还是ODBC'


BTW:

MS说是什么问题~

[zyhowe]

OracleInProcServer.XOraSession

这个就是Oracle自己的


ASP中OracleInProcServer.XOraSession,OraSession怎么总是丢失?

只是select出现,只要是联合主键的情况

[aceplus]

如果 unique index/primary key 是联合主键的时候；

好像只能取第一个字段或者干脆rowid。

实在不行，显式的order by (desc)

[zyhowe]

正解!