>How are you determining that the simultaneous hits are getting mixed together? What kind of errors are you getting?

I look at my log and am able to find a hit at the same second at the time of the error of the other hit.

Here is one that is really annoying. On the following SQL command, there is no parameter defined. So, an error was given today on that one but I can execute that SQL as is without any problem if I go directly in VFP:

Syntax error.

SELECT Master.Numero,Master.FirstName,Master.LastName,Master.Born,Master.Decease,Master.BornYear,Master.DeceaseYea,Master.NoSchool,;
 Master.NoMaster,MasterType.Title_E,MasterType.Title_F,Master.WikiUrl_E,Master.WikiUrl_F,Master.WikiTitl_E,Master.WikiTitl_F,;
 IIF(ISNULL(MasterDefinition.Notes_E),"",MasterDefinition.Notes_E) AS Notes_E,;
 IIF(ISNULL(MasterDefinition.Notes_F),"",MasterDefinition.Notes_F) AS Notes_F,;
 Master.Url FROM Master
 LEFT JOIN MasterDefinition ON Master.Numero=MasterDefinition.NoMaster AND MasterDefinition.NoMasterC=14;
 INNER JOIN MasterType ON Master.NoMasterT=MasterType.Numero;
 WHERE Master.Numero=157 ORDER BY Master.LastName,Master.FirstName

And, here is another one that I get several times a day about the OleDb provider complaining about a missing field. But, it is not the case. Everything is ok with that command. Again, there is no parameter defined on that SQL:

SQL: Column 'NOMASTER' is not found.

SELECT Video.Numero,Video.Active,Video.Date,Video.Notes_E,Video.Notes_F,Video.Running,Video.Title,Video.NoVideoT,Master.FirstName,;
 Master.LastName,Video.NoVideoL,Video.NoMaster,Video.NoMaster2,Video.NoMaster3,Video.NoMember,;
 VideoType.Title_F AS VideoType,VideoLanguage.Title_F AS VideoLanguage,Program.Title AS Program,Video.NoProgram,;
 IIF(ISNULL(Member.NoSchool),0,Member.NoSchool) AS NoSchool,School.Title AS School,Video.NoClass,;
 VideoClassification.Title_F AS Classification,Video.Url,School.Url AS SchoolUrl,;
 VideoSize.Title AS VideoSize,VideoSize.Width,VideoSize.Height,Video.NoMember2,Member2.FirstName,Member2.LastName;
 FROM Video;
 INNER JOIN Master ON Video.NoMaster=Master.Numero;
 INNER JOIN VideoType ON Video.NoVideoT=VideoType.Numero;
 INNER JOIN VideoLanguage ON Video.NoVideoL=VideoLanguage.Numero;
 LEFT JOIN Program ON Video.NoProgram=Program.Numero;
 LEFT JOIN Member ON Video.NoMember=Member.Numero;
 LEFT JOIN School ON Member.NoSchool=School.Numero;
 INNER JOIN VideoClassification ON Video.NoClass=VideoClassification.Numero;
 INNER JOIN VideoSize ON Video.NoVideoSiz=VideoSize.Numero;
 LEFT JOIN Member AS Member2 ON Video.NoMember2=Member2.Numero;
 WHERE Video.Active AND Member.NoSchool=230 AND Video.Date<={^2006/09/24 19:25:17} ORDER BY Video.Title

And, here is another one. Again, there is no parameter defined:

SQL: Column 'NOMASTER' is not found.

SELECT Master.Numero,Master.FirstName,Master.LastName,Master.Born,Master.Decease,Master.BornYear,Master.DeceaseYea,Master.NoSchool,;
 Master.NoMaster,MasterType.Title_E,MasterType.Title_F,Master.WikiUrl_E,Master.WikiUrl_F,Master.WikiTitl_E,Master.WikiTitl_F,;
 IIF(ISNULL(MasterDefinition.Notes_E),"",MasterDefinition.Notes_E) AS Notes_E,;
 IIF(ISNULL(MasterDefinition.Notes_F),"",MasterDefinition.Notes_F) AS Notes_F,;
 Master.Url;
 FROM Master;
 LEFT JOIN MasterDefinition ON Master.Numero=MasterDefinition.NoMaster AND MasterDefinition.NoMasterC=14;
 INNER JOIN MasterType ON Master.NoMasterT=MasterType.Numero;
 WHERE Master.Numero=119 ORDER BY Master.LastName,Master.FirstName

And, here is another syntax error. This time there are two parameters. But, there is no syntax error:

Syntax error.

SELECT Message.Notes_F AS String FROM Message WHERE UPPER(Message.Module)=? AND UPPER(Message.Key)=?

Module=STYLE               
Key=COUNTRYOFORIGIN