Date parsed: 9/20/2000 9:07:57 PM
Date: Wed, 20 Sep 2000 20:07:57 +0200

Tried both.

"Franz Krainer" <franzk@netal.com> wrote in message
news:3A25DBCDF73F2245957BD0B041BEDAF00170DA@is1.netal.com...
> 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
> >
>