How to switch DSN in business operations？

Question

Question

Zhang Fatong · Nov 18, 2021

I want to switch between different DSNs in business operations to query different servers, but the DO ..Adapter.DSNSet("DSNName") code will report a 15-second connection timeout error when switching DSNs. What should I do?

Product version: IRIS 2020.1

Discussion (4)1

Log in or sign up to continue

Eduard Lebedyuk Nov 19, 2021 to Zhang Fatong

Have you tried connecting to this second DSN right from the start?

0 0

score 0 · Answer 1 · 2021-11-19T00:56:34-05:00

Eduard Lebedyuk · Nov 19, 2021

Which adapter are you using?

0 0

score 0 · Answer 2 · 2021-11-19T01:03:42-05:00

Zhang Fatong Nov 19, 2021 to Eduard Lebedyuk

EnsLib.SQL.OutboundAdapter

0 0

score 0 · Answer 3 · 2021-11-21T21:29:32-05:00

Zhang Fatong Nov 21, 2021 to Eduard Lebedyuk

Yes, I tried.
Both DSNs can be used normally, but I have to judge in the program to choose a different DSN

0 0