Date parsed: 9/19/2000 6:42:15 PM
Date: Tue, 19 Sep 2000 17:42:15 +0200

Problem: Logging is not working to and Oracle database.

Steps to reproduce:
1) Create a ODBC source using Microsoft's latest Oracle ODBC driver
(2.573.5303.00).
2) In the server field, enter the database SID name (e.g., ORCL) that
resolves to a valid TNSName.
3) In the username field enter <username>/<password>. Leave the =
password
field blank.
4) Using ODBC Test (or another ODBC capable application), attempt to =
connect
to the database without entering any additional parameters, usernames or
passwords. If it succeeds, you are properly configured.
5) Now configure SL4NT to use that connection name.

Result:
Event log 'Unable to log to ODBC source'.

Notes:
1) What exactly is SL4NT looking for in order to form a connection? =
Some
ODBC drivers want Username and Password specified. Some will not allow =
you
to enter the password in the ODBC DSN. In Oracle's case, you can enter =
the
username and password on the same line using the syntax shown above. =
You
can also do this with Microsoft's driver.

2) I created the tables using both short and long names. I also made =
sure
the user created for the ODBC driver could manually enter data into the
table through ODBC using the ODBC Test application.

3) The database is an Oracle 8i database. I also tried using Oracle's
latest driver (8.01.06.00) with similar results. In this case entries =
where
not found in the database also but no errors were found in the =
Application
Log. Perhaps the data is not being committed by the application before =
the
session ends?

Thanks for your help!.....Gregg