Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC .NET Timeout

Status
Not open for further replies.

jwmoore

IS-IT--Management
Dec 1, 2006
2
US
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 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...
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top