For over 6 months, I have been working with remote views to SQL without any problems. About 3 weeks ago, I began having problems with my application. Everything seemed to slow to a crawl. These are test databases and no additional data has been added to the databases in the last 6 months. A form which once loaded in less than 30 seconds can take 5 minutes just to load. I played with the Fetchsize and Share settings with no luck. I get a "Function Sequence Error" from ODBC if I try to share the connection or set Fetchsize to -1.

According to the network/SQL administrator, no changes have been made to the network, ODBC or the SQL setup (I have to take his word on this). When I try to modify a view in the database (change the fetchsize, etc.), it takes the system over 5 minutes just to save the file. Sometimes, it seems to hang almost indefinitely. What would cause such slow database access? I tried every machine on the network with the same results. I am being blamed for this problem, but am clueless. An application that used to run, no longer runs. No changes were made to the data or application.

Please help...

Monique