IIS Log into Oracle

Hi volkhard,

Thank you for posting in MSDN managed newsgroup!

I think the suggestion from Egbert is very useful for you on this issue. You should first create one table of a database in Oracle as Egbert has
specified. Then create one ODBC linkage to the Oracle with Microsoft ODBC for Oracle in the Data Source from the administrative tool of control
panel. After that, please open the IIS mmc and click for the property window of the specified site. In WebSite tab, you will find the "Enable Logging"
area, choose the "ODBC Logging" and then click "properties..." button to link to the ODBC data source you have created for Oracle.

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: IIS Log into Oracle 

Hello Egbert,

thanks for your hints - but it doesen=B4t work.

i tried this but the eventlog gives following message:

IIS ODBC Logging failed to connect to data source wxpnb2.=20
Error text is [[State=3DIM004][Error=3D0][Microsoft][ODBC=20
Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV=20
failed
].=20

when i try to use the system-Datasource in an udl-file and=20
test it, everythink is ok.

best regards

Volkhard

 >-----Original Message-----
 >"volkhard vogeler" <VolkhardV.RemoveThis@Vogeler-ag.de> wrote in=20
message
 >news:01f001c3aeda$ef098d30$a501280a@phx.gbl...
  >> Hello,
  >>
  >> it is possible to log IIS into a oracle database?
 >Yes it is, just create a odbc DSN or connection string to=20
it...
 >But you need to convert tabel below to a oracle=20
compatible type...
 >create table inetlog (
 >
 >ClientHost varchar(255), username varchar(255),
 >
 >LogTime datetime, service varchar( 255), machine varchar(=20
255),
 >
 >serverip varchar( 50), processingtime int, bytesrecvd int,
 >
 >bytessent int, servicestatus int, win32status int,
 >
 >operation varchar( 255), target varchar(255), parameters=20
varchar(255) )
 >
 >
  >> best regards
 >
 >.
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: IIS Log into Oracle