I've been reviewing the threads without success looking for a solution to what I hope is a simple problem.
I am writing a quick and dirty C# .NET 2.0 app to pull data from the AR History Header and Details files. I've got a good connection string and SQL query, but I keep getting a timeout error from the ProvideX driver within the C# app.
I've tried setting the OdbcDataAdapter ConnectionTimeout property higher (default is 30 secs), but it seems to have no effect. Is there another setting I am missing or a setting on the connection string itself? I've looked at the docs on providex's website and didn't see anything that looked relevant for setting timeouts on the connection string, but I may have missed something. This same query does take a while but completes successfully in Excel.
I am using MAS200 4.10, SOTAMAS90 V4.00. Any thoughts?
Thanks
I am writing a quick and dirty C# .NET 2.0 app to pull data from the AR History Header and Details files. I've got a good connection string and SQL query, but I keep getting a timeout error from the ProvideX driver within the C# app.
I've tried setting the OdbcDataAdapter ConnectionTimeout property higher (default is 30 secs), but it seems to have no effect. Is there another setting I am missing or a setting on the connection string itself? I've looked at the docs on providex's website and didn't see anything that looked relevant for setting timeouts on the connection string, but I may have missed something. This same query does take a while but completes successfully in Excel.
I am using MAS200 4.10, SOTAMAS90 V4.00. Any thoughts?
Thanks