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

>