ODBC Logging with ORACLE

[lucib23]

Hello to all.

I use IIS 5 and ODBC Logging. When i use an ODBC connection to MsAccess, everything works fine, IIS logs the activities. When i use an ODBC conection with Oracle, even though i have the same table in Oracle, IIS won't insert anything in it.
The ODBC system connection works fine, i can retrieve data from the same table.

Any ideeas?
Thanks,
LuciB23

[bakedjake]

Any ideeas?

MS and Orcale have different SQL syntax at times. Did you try running the PUT query in a direct SQL session with the Oracle DB and checking your results?

[lucib23]

I didn't tried the PUT in a direct connection with Oracle,
because i don't know how IIS tries to insert data in a table; which query it uses. I tried to "catch" the query in Oracle, but the only queries that appeared were the one's retrieving the data from the table.

[bakedjake]

but the only queries that appeared were the one's retrieving the data from the table

It's possible that your ASP code isn't correct. Can you post a snippet where you're trying to insert data into the database?

[nevermind]

[edited by: bakedjake at 4:02 pm (utc) on Sep. 11, 2003]

[lucib23]

Actually I have no code at all.
I try to insert the logs that IIS generates into an Oracle database. i have the table definition, and this works well for Msaccess( setting an ODBC System connection, and configuring IIS to put data there). The same thing doesn't works for a ODBC conection to oracle, allthough all conditions are met: table created, ODBC connection works(i tried from asp and I can read the table trough the ODBC connection).

4 this i have no other explanation than the fact that the SQL queries that IIS sends are not good for oracle.

[bakedjake]

Oh! I misunderstood, sorry!

The only thing I can think of are the differences in the table definitions between Oracle and Access.

This is the site I have in my bookmarks regarding ODBC logging: [docs.rinet.ru:8083...] It sounds like you're well past the documentation, though. :-(

It could be query differences too, but ODBC is supposed to take care of that AFAIK. Did you look in Google Groups? I'm sure someone is logging to Oracle.