I get the following error:
*************************************************************
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','.
/statistiek/metatraffic2/clsLog.asp, line 304
**************************************************************
What am I doing wrong??
SQL Error
In version 2.00 Lite that is...., with asp.tracking
SQL Error
Hi,
That is strange. I assume you ran the setup to install or upgrade MetaTraffic 2?
Can you add a debug line in the code and post the results back? Open the clsLog.asp file in a text editor and on line 303, insert the following line of code:
Response.Write strSql
Now load the track.asp script directly in your web browser, the url should be something like:
http://www.yourdomain.com/statistiek/metatraffic2/track.asp
It should display the SQL query that is causing the problem. If you could post that back on this forum, that would be great.
Thannks,
~Chad
SQL Error
OK. I will try it tomorrow morning and let you know what happens.
The strange thing though is, that when I refresh te page that is being tracked, it appears without the error.
So every page that is loaded for the first time, gets the error, and after refresh it is loaded ok....??
SQL Error
I get the following response.write:
INSERT INTO mt_PageLog (pl_datetime, pl_pn_id, pl_r_id, pl_s_id) VALUES('2004-08-26 08:00:22', 10, 0, 430438326)
Hope you know what the problem is.
SQL Error
Hi,
Do you know what beta version you are running? Check the readme file included with it and you can tell by looking at the version history.
Are you sure this was what was displayed before you got the error? Or was this displayed on a subsequent page reload when no error ocurred? I can't see anything wrong with the sql statement you posted. Please make sure that you post the sql statement that is displayed when you get the ASP error.
Regards,
~Chad
SQL Error
Hi,
I'm using version 2.0 beta 7.
I'm all lost now.
When I surf on my localhost, everything seems ok.
When I surf on a other pc, I first get a "can't find this page" page and after a refresh the page is loaded right.
So I guess there is no problem with metatraffic but that I have some kind of problem with connection to the sql database or permissions or something like that.
Anyway, thanks a lot for your help and my compliments for the very fine metatraffic software. It is the best I've found.