ODBC .NET Timeout

[jwmoore]

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

 

[rainxking]

I ran into other issues (but not this one...) The solution I came up with was to copy the MAS tables into SQL and then running the .net apps off that. update every 2 hours brcause I don't need it in real time.

hope it helps...

 

[jwmoore]

Thanks. I was trying to avoid duplicating data as the invoice history file is quite large (a problem for another day). I've worked around the problem by breaking the query down into multiples, but would still like to know for future reference.

I'm new to the forum here but from what I can see, I will be back. Looks to be a treasure trove of information and people with the know how to make it all work.