Date parsed: 9/19/2000 10:08:34 PM
Date: Tue, 19 Sep 2000 21:08:34 +0200

Did you create a User-DSN or a System-DSN? SL4NT can only use =
System-DSNs
because it is running as a service in the System account.

Franz

"Gregg Lagnese" <microd@radix.net> wrote in message
news:3A25DBCDF73F2245957BD0B041BEDAF00170C4@is1.netal.com...
> 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
>