Re: ISA Logging to Oracle 9.2 database[AV Scanned]
- From: "Thomas W Shinder" <tshinder@xxxxxxxxxxx>
- To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
- Date: Tue, 13 Apr 2004 08:59:09 -0500
Hey guys,
I have an article on this. I'll try to get it posted today.
Thanks!
Tom
Thomas W Shinder
www.isaserver.org/shinder
ISA 2004 Beta - Get it now!
http://www.microsoft.com/isaserver/beta/default.asp
ISA Server and Beyond: http://tinyurl.com/1jq1
Configuring ISA Server: http://tinyurl.com/1llp
-----Original Message-----
From: Steve Fenwick [mailto:Steve.Fenwick@xxxxxxxxxxxx]
Sent: Tuesday, April 13, 2004 8:54 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] Re: ISA Logging to Oracle 9.2 database[AV Scanned]
http://www.ISAserver.org
Hi Joseph,
Just downloaded that one and will try soon. So far I have tried
1. Oracle 9.0.2 driver from the Oracle Client CD.
2. Microsoft ODBC driver for Oracle.
Neither one works from ISA server, however access can read & write to
Oracle through both drivers.
If I set ODBC logging to Access I get logs created from ISA
If I set ODBC to SQL Server I also get logs created from ISA
If I set ODBC to access which links via ODBC to Oracle then nothing is
produced, even though access CAN write to Oracle.
We are currently logging to SQL Server, but most of our expertise (to
say nothing of all the other log databases) are stored in oracle so we
really want to log to oracle.
Currently considering using a trigger in SQL server to forward the rows
to Oracle. Hell of a sledgehammer to crack a Nut.
Thanks
Steve
-----Original Message-----
From: cismic [mailto:cismic@xxxxxxx]
Sent: 13 April 2004 14:45
To: [ISAserver.org Discussion List]
Subject: [isalist] Re: ISA Logging to Oracle 9.2 database[AV Scanned]
http://www.ISAserver.org
Hi Steve,
Have you loaded the right ODBC driver for ORACLE windows?
http://otn.oracle.com/software/tech/windows/odbc/index.html
A lot of times one driver won't work with sql, access etc.
I would create all the columns, in oracle to be of mixed case with
at least have them all variable length fields and allow nulls for each
field. Because of the differences in date and time fields try and make
those fields alpha/numeric as well.
HTH,
Joseph
----- Original Message -----
From: "Steve Fenwick" <Steve.Fenwick@xxxxxxxxxxxx>
To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
Sent: Tuesday, April 13, 2004 2:40 AM
Subject: [isalist] ISA Logging to Oracle 9.2 database
http://www.ISAserver.org
Hello All,
Hope somebody can help here.
We have an ISA server, configured to log to file. We would like to
configure it to log to Oracle. (Oracle 9.2.0.4). I have meticulously
followed your tutorial and while ISA server starts up and runs, we get
nothing written to Oracle.
The only service configured is WebProxyLog.
ISA server is running on Windows 2003 server.
Oracle 9.2.0.4 is running on Windows XP (SP1)
ODBC works I can access my Access database and manually add records -
these records then appear in Oracle.
I restart Web Proxy Service and it starts successfully, however nothing
ever gets written to Oracle.
I have dropped Oracle table and re-created to obtain mixed case column
names.
I hope that you can help.
Best Regards
Steve Fenwick
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
cismic@xxxxxxx
To unsubscribe send a blank email to
$subst('Email.Unsub')
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
steve.fenwick@xxxxxxxxxxxx
To unsubscribe send a blank email to
$subst('Email.Unsub')
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
tshinder@xxxxxxxxxxxxxxxxxx
To unsubscribe send a blank email to $subst('Email.Unsub')
Other related posts:
