[ASP.NET]如何 解決The state server has closed an expired TCP/IP connection(How to solve the state server has closed an expired TCP / IP connection)

問題

---

解決The state server has closed an expired TCP/IP connection


解決方法

---

1.Web.config stateNetworkTimeout加大(秒)

 <sessionState 
            stateNetworkTimeout="10"
        />

2.調整ASP.NET state server
 Step1.服務=>ASP.NET State server=>停用
 Step2.執行=>Regedt32.exe
 Step3.找到HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\aspnet_state\Parameters
 Step4.右鍵=>新增DWORD=>SocketTimeout=>輸入整數時間
 Step5.服務=>ASP.NET State server=>自動

參考https://support.microsoft.com/en-us/help/308097/state-server-logs-event-id-1072-or-event-id-1076

[C#]如何 不安裝OracleClient使用OraOLEDB.Oracle.1連OracleDB(How to use OraOLEDB.Oracle.1 to connect DB without installing Oracle Client)

問題

---

如何 不安裝OracleClient使用OleDbDataAdapte provider=OraOLEDB.Oracle.1連 OracleDB r


解決方法

---

1.下載ODAC(for 10 g使用ODAC 11.2 Release 6 (11.2.0.4.0)版本)

2.解壓縮後開cmd=>輸入[cd 解壓縮目錄]切換路徑=>輸入如下

install.bat oledb     c:\oracle myhome true

3.系統環境變量設置=>系統=>進階系統設定=>環境變數,Path點選編輯輸入如下(設定後需要重開機)

c:\oracle;c:\oracle\bin

4.連線設定放置tnsnames.ora於C:\oracle\network\admin底下

5.程式連線設定

Provider=OraOLEDB.Oracle.1;Data Source=DBnameInTNS;User ID=test;Password=test;;Persist Security Info=False

[PL/SQL Developer]如何 不安裝OracleClient連OracleDB(How not to install Oracle Client even OracleDB in PL/SQL Developer)

問題

---

如何 不安裝OracleClient連OracleDB


解決方法

---

先下載Instant Client Package,請參考
於PL/SQL Developer=>Tools=>Preferances=>

Oracle Home=>輸入Instant Client位置
OCI Libary=>輸入Instant Client位置\oci.dll