IIS logging into Oracle database

From: Jan Poot <jpoot_at_netaspect.nl>
Date: Thu, 5 Aug 1999 17:51:56 +0200
Message-ID: <7ocbvs$nd5$1@news1.xs4all.nl>

I am trying to store the logging of Microsoft Internet Information Server into an Oracle database, using an ODBC connection. This does not work. There are no records appearing in the table and the logfile of ODBC shows an error from inetinfo:

[Microsoft][ODBC driver for Oracle][Oracle]ORA-00904: invalid column name (904)

The command is:

"insert into weblog ( "ClientHost", "username", "LogTime", "service",
"machine", "serverip", "processingtime", "bytesrecvd", "bytessent",
"servicestatus", "win32status", "operation", "target", "parameters") values
( ?, ?, ?, 'W3SVC4', 'IIS_SERVER', ?, ?, ?, ?, ?, ?, ?, ?, ?)\ 0" I tested the ODBC connection and the rights on the database. These seems ok.

It looks like the failure is:
- double quotes around the fieldnames
- question mark is not accepted as fieldvalue

Does anyone know if there are settings on Oracle or IIS, so that the logrecords do appear?

Jan Poot
System engineer
MCP
jpoot_at_netaspect.nl

--
NetAspect B.V.

Jan Poot
System engineer Received on Thu Aug 05 1999 - 10:51:56 CDT