Weird. I have no ideas at the moment. I think I'll sleep on it ... I might have a suggestion in the morning (but I'm not promising anything <g>).

~~Bonnie



>>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
>