Information générale
Titre:
Access Passthrough Query Crashing System every time
The following code crashes an instance of VFP 6 SP3 every time.
lcQuery = "SELECT Finder.Source FROM Finder, Orders WHERE Finder.FinderNo = Orders.FinderNo GROUP BY Finder.Source"
lnResult = SQLEXEC(lnConnect,lcQuery,"Sample")
Finder table contains roughly 1,000,000 records.
Orders table contains roughly 60,000 records.
All tables are indexed.
When the tables are smaller the SELECT statement works correctly and retrieves expected results.
I am wondering if there are stored procedures I can execute?
What about the SQLSTRINGCONNECT command ?
Is there something in that command that I can change to allow this kind of query to not crash the system...
lcConnect = "DBQ=" + "\\opserver2\data1\opdb\backend\usmts.mdb" + ";" + ;
"DEFAULTDIR=" + "\\opserver2\data1\opdb\backend\" + ";" + ;
"Driver={Microsoft Access Driver (*.mdb)};DriverId=281;" + ;
"FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;"
I tried changing MaxBufferSize to a significantly larger number and the hard drive just kept going and going... until I issued {CTRL-ALT-DLT} and clicked "End Task" command button.
I tried increasing the size of the 'PageTimeout' command switch.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement