Smitty2003
MIS
I'm trying to pull some information from the master inventory file from the Mas200 DSN. I can perform specific queries just fine (one's that return 1 row). I am having trouble getting large queries to work. I get
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[ProvideX][ODBC Driver]Timeout error.
when I run the query from a web page. I have tried bumping up all the timeouts periods for IIS and what not. I know there is a SQL_QUERY_TIMEOUT, but I do not know how to use it. Can anyone assist me in figuring this out? Thanks in advance.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[ProvideX][ODBC Driver]Timeout error.
when I run the query from a web page. I have tried bumping up all the timeouts periods for IIS and what not. I know there is a SQL_QUERY_TIMEOUT, but I do not know how to use it. Can anyone assist me in figuring this out? Thanks in advance.