IIS 6 logging to Oracle Database

OK, after many hours of frustration here is what made it work.
First here is the system
IIS6 - machine 1
Oracle 9i - machine2
MS ODBC driver for Oracle in use on IIS machine 1

After a network capture of the data moving around, I found that the column
names being sent by IIS are not exactly as listed by Microsoft. Since IIS
is sending the column identifier in quotes, Oracle is treating it as
case-SENSITIVE. So when I caught the packet containing the insert statement
this is what I found.
What MS says: What IIS really sends:
ClientHost ClientHost
Username username
LogTime LogTime
Service service
Machine machine
ServerIP serverip
ProcessingTime processingtime
BytesRecvd bytesrecvd
BytesSent bytessent
ServiceStatus servicestatus
Win32Status win32status
Operation operation
Target target
Parameters parameters

The Oracle table must be created with the field identifiers from the second
column above, enclosed in double quotes. ex. create table "IISLOG"."PITA"
("ClientHost" varchar2(255), "username"varchar2 (255), . . . ) tablespace
blah.

The general names of the column identifiers given by MS documentation is
good, but they do not take into account the quotes making Oracle see them as
case-sensitive. I hope this will help someone else out someday.

Regards,

Nate

"Egbert Nierop (MVP for IIS)" <egbert_nierop.TakeThisOut@nospam.invalid> wrote in
message news:OB1wYGirEHA.2580@TK2MSFTNGP15.phx.gbl...
 > Try to enable ODBC logging and see if security or any permission problem
 > is happening.
 > In addition, open Oracle SQL (I forgot that tool's name) where you can
 > directly test INSERT / SELECT / DELETE / UPDATE statements and see if you
 > get any errors.
 >
 > If nothing helps, you'll need to create a custom Logging module (a COM
 > component) for which the IIS SDK provides samples.
 >
 > --
 > compatible web farm Session replacement for Asp and Asp.Net
<font color=purple> > <a style='text-decoration: underline;' href="http://www.nieropwebconsult.nl/asp_session_manager.htm</font" target="_blank">http://www.nieropwebconsult.nl/asp_session_manager.htm</font</a>>
 >
 > "Bert" <ntwager.TakeThisOut@hotmail.com> wrote in message
 > news:662af81b.0410090738.1af30bae@posting.google.com...
  >> Hello,
  >>
  >> I need to log the events on my IIS servers to an Oracle 9i database.
  >> Has anyone got this to work????
  >>
  >> I have tried both the Oracle ODBC driver and the MS for Oracle driver.
  >> I get no data in the Oracle DB, but when I verify the System DSN in
  >> ODBC ctl panel, I get a successful connection everytime. I have
  >> recreated the DB table with quotes and without, made the Oracle
  >> account DBA. I need to get this working quickly, and I know it is
  >> possible, but what am I missing????
  >>
  >> Regards,
  >>
  >> Nate
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: IIS 6 logging to Oracle Database 

"Kelty" <kelty.RemoveThis@hotmail.com> wrote in message
news:jHV9d.103205$nA6.55239@twister.rdc-kc.rr.com...
 > OK, after many hours of frustration here is what made it work.
 > First here is the system
 > IIS6 - machine 1
 > Oracle 9i - machine2
 > MS ODBC driver for Oracle in use on IIS machine 1

You could have save that time :<
when you had found c:\windows\system32\inetsrv\logtemp.sql
See contents below...

Note that it does not support unicode or utf-8 so this logging solution is
not suited for pages that have non ansi chars.

 > After a network capture of the data moving around, I found that the column
 > names being sent by IIS are not exactly as listed by Microsoft. Since IIS
 > is sending the column identifier in quotes, Oracle is treating it as
 > case-SENSITIVE. So when I caught the packet containing the insert
 > statement this is what I found.
 > What MS says: What IIS really sends:
 > ClientHost ClientHost
 > Username username
 > LogTime LogTime
 > Service service
 > Machine machine
 > ServerIP serverip
 > ProcessingTime processingtime
 > BytesRecvd bytesrecvd
 > BytesSent bytessent
 > ServiceStatus servicestatus
 > Win32Status win32status
 > Operation operation
 > Target target
 > Parameters parameters


create table inetlog (
ClientHost varchar(255), username varchar(255),
LogTime datetime, service varchar( 255), machine varchar( 255),
serverip varchar( 50), processingtime int, bytesrecvd int,
bytessent int, servicestatus int, win32status int,
operation varchar( 255), target varchar(255), parameters varchar(255) )



 > The Oracle table must be created with the field identifiers from the
 > second column above, enclosed in double quotes. ex. create table
 > "IISLOG"."PITA" ("ClientHost" varchar2(255), "username"varchar2 (255), .
 > . . ) tablespace blah.
 >
 > The general names of the column identifiers given by MS documentation is
 > good, but they do not take into account the quotes making Oracle see them
 > as case-sensitive. I hope this will help someone else out someday.
 >
 > Regards,
 >
 > Nate
 >
 > "Egbert Nierop (MVP for IIS)" <egbert_nierop.RemoveThis@nospam.invalid> wrote in
 > message news:OB1wYGirEHA.2580@TK2MSFTNGP15.phx.gbl...
  >> Try to enable ODBC logging and see if security or any permission problem
  >> is happening.
  >> In addition, open Oracle SQL (I forgot that tool's name) where you can
  >> directly test INSERT / SELECT / DELETE / UPDATE statements and see if you
  >> get any errors.
  >>
  >> If nothing helps, you'll need to create a custom Logging module (a COM
  >> component) for which the IIS SDK provides samples.
  >>
  >> --
  >> compatible web farm Session replacement for Asp and Asp.Net
<font color=green>  >> <a style='text-decoration: underline;' href="http://www.nieropwebconsult.nl/asp_session_manager.htm</font" target="_blank">http://www.nieropwebconsult.nl/asp_session_manager.htm</font</a>>
  >>
  >> "Bert" <ntwager.RemoveThis@hotmail.com> wrote in message
  >> news:662af81b.0410090738.1af30bae@posting.google.com...
   >>> Hello,
   >>>
   >>> I need to log the events on my IIS servers to an Oracle 9i database.
   >>> Has anyone got this to work????
   >>>
   >>> I have tried both the Oracle ODBC driver and the MS for Oracle driver.
   >>> I get no data in the Oracle DB, but when I verify the System DSN in
   >>> ODBC ctl panel, I get a successful connection everytime. I have
   >>> recreated the DB table with quotes and without, made the Oracle
   >>> account DBA. I need to get this working quickly, and I know it is
   >>> possible, but what am I missing????
   >>>
   >>> Regards,
   >>>
   >>> Nate
  >>
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: IIS 6 logging to Oracle Database