all groups > iis ftp > april 2006 >
You're in the

iis ftp

group:

ODBC logging inserts forward slash in front of 'target' column dat


ODBC logging inserts forward slash in front of 'target' column dat Mike Barnett
4/17/2006 11:01:22 AM
iis ftp: I have an application I've been running for over two years on three different
Windows 2000 Servers, but it fails on Windows 2003 Server (SP1, standard,
32-bit).

The reason the app fails is that IIS on the Win 2003 Server inserts a
forward slash in front of the file name in the 'target' column of the Inetlog
table to which I'm loggig FTP activity. This does not happen with the older
W2K Server systems.

For example, the entry in the 'target' column of Inetlog on the 2003 server
is "/CASE_20060415062506.TXT", whereas on the 2000 Server, it's
"CASE_20060415062506.TXT". The trigger on the 'target' column is looking for
the name "CASE_<date-time stamp>.TXT", of course.

I tried "lcd"ing to the local directory where the source file lives to see
if that would make a difference, but it doesn't. There is nothing in any of
my scripts which would affect this, and I can't find anything else related to
IIS logging which might explain it.

Has anyone else seen this anomaly?
--
Re: ODBC logging inserts forward slash in front of 'target' column Mike Barnett
4/18/2006 10:16:01 AM
OK, I give up. I searched TechNet and even the W3C standards for logging, but
can find no clue as to why MS changed the format of the 'target' field to
include a leading slash in front of the file name. BC is right, the only
thing I can do is change the trigger filter to include the slash, which I
did, and now the app runs, but I'm still frustrated that MS has once again,
without explanation, made a change to a product which causes existing code to
crash.
--
OUM


[quoted text, click to view]
Re: ODBC logging inserts forward slash in front of 'target' column dat Bernard Cheah [MVP]
4/18/2006 5:40:04 PM
I don't have ODBC logging to test now. but if IIS 6 logging detail changed
from 5, I guessed you need to change your app to fit it.

--
Regards,
Bernard Cheah
http://www.iis-resources.com/
http://www.iiswebcastseries.com/
http://msmvps.com/blogs/bernard/


[quoted text, click to view]

Re: ODBC logging inserts forward slash in front of 'target' column Bernard Cheah [MVP]
4/19/2006 9:15:18 PM
Oh well, you are talking about Microsoft....., aren't you ? :)

--
Regards,
Bernard Cheah
http://www.iis-resources.com/
http://www.iiswebcastseries.com/
http://msmvps.com/blogs/bernard/


[quoted text, click to view]

AddThis Social Bookmark Button