Hi,
I just deployed the latest version of metatraffic and it worked for a few hours. Now, it has seemed to affect other scripts running on the page.
I am using <% Server.Execute("/metatraffic/track.asp") %> to call the script. I also have other sql queries running on the same page, and the one that it is affecting is
<%set rs=conn.execute("select top 1 * from tblnews where newsdate>='" & date & "' order by newsdate")
this line selects the next news item based on the date. Similar scripts which select things based on date also crash with a error message similar to the folowing:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The funny thing is that once I comment-out the metatraffic call, everything returns to normal.
Any ideas?
Adam
PS> When it is running and I get that error, metatraffic still collect the data