请问OracleDataAdapte有没有读取的超时设置？

Question

     OracleConnection connection = new OracleConnection(CRMconnectionString);
                OracleDataAdapter adapter = new OracleDataAdapter(queryString, connection);

                // Fill the DataSet.
                adapter.Fill(ds, "result");

Answer 1

Hello,

>>请问OracleDataAdapter有没有读取的超时设置？

既然是ADO.NET的话，那应该是有的，通常是在连接字段是设置的:,

你可以看下这个thread:

https://social.msdn.microsoft.com/Forums/en-US/8866ee03-c19b-46c9-acdb-19e424c20c08/timeout-on-dataadapterfill-on-strongly-typed-dataset?forum=adodotnetdataproviders

Regards.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

adapter.SelectCommand.CommandTimeout

---

http://feiyun0112.cnblogs.com/

Answer 3

Data Source=ods_b11;Persist Security Info=True;User ID=a;Password=xxx;Unicode=True;Connect Timeout=3600 

执行报错

不支持关键字: “connect timeout”。

Answer 4

是 ConnectionTimeout 才對

http://docs.oracle.com/html/E10927_01/OracleConnectionClass.htm#i1000566

---

大家一齊探討、學習和研究，謝謝！
MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA, MCTS, MCITP, MCPD,
MCT, Microsoft Community Star(TW & HK),
Microsoft MVP for VB.NET since 2003
My MSMVP Blog

請記得將對您有幫助的回覆標示為解答以幫助其他尋找解答及參與社群討論的朋友們。
Please remember to clickMark as Answer on the post that helps you. This can be beneficial to other community members reading the thread.