Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-08 : 19:00:14
|
Andrew writes "Here's the situation: NT server (4.0 / sp6), Novell Netware (4.11), IIS (5.0). Data files are free Visual Fox 6.0 tables on the Novell server. ASP data retrieval worked fine in test mode using Personal Web Server, but would not work at all in real life. Error messages indicated that the data files did not exist.
We searched the web and found a Microsoft PRB (Q236019) that stated: "The Visual FoxPro ODBC Driver can process queries in the background. This "background fetching" feature, also called progressive fetching or asynchronous fetching, should be disabled if the ODBC driver is being called by a multi-threaded application such as ASP."
OK. So we disabled the background fetch in the DSN setup, and the ASP page worked fine ... for about 20 minutes. After that, nothing. Nada. Bupkis. Not only that, the Cold Fusion (4.5)pages that have been going after these same VFP tables for many months don't work any longer. We have re-booted the server, re-created the DSN definitions, changed back to background fetch, all to no avail.
What on earth is going on??" |
|
|
|
|
|
ASP and FoxPro