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

> >

>