I've changed the timeout to 600 seconds and I still get nothing returned.
The query is fairly simple and indeed returns quickly when run against a qualification server which contains the same information.
Initially I thought I was able to connect from another machine but actually my configuration was incorrect. What I'm seeing now is that:
- I cannot connect to a remote AF server db via PI OLEDB Enterprise used in .net program
- I've tried to connect from 2 separate servers
- On both machines I can connect to same db via PI System Explorer
- I can connect to another remote AF server db from both servers via the same .net program
OLE DB Enterprise 2017 R2
OLE DB Provider version 184.108.40.206
AF Client / AF Server version 220.127.116.1185
This is the error I'm gettting:
2019-01-07 11:38:43,777 [ 21] ERROR PIOLEDBENT - [mscorlib] The request channel timed out while waiting for a reply after 00:04:59.9532024. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout.
What does the connection string look like that your application is using to initialise the PI OLEDB Enterprise Provider? What are the effective credentials being used by your application to connect to the server in question?
What is the exact query being made? You could set your timeout parameter to 0 to disregard the timeout altogether. I would also recommend moving away from PI OLEDB Enterprise in favor of PI SQL Client and the RTQP Engine. These were developed for known performance limitations of the PI OLEDB Providers.