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