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

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

EnsLib.SQL.OutboundAdapter

0 0

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

Zhang Fatong · Nov 21, 2021

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

0 0