Re: The question about Asp connect the Oracle ODBC

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Wed, 8 Jul 1998 12:54:40 +0200
Message-ID: <6nvj25$n8p$1@hermes.is.co.za>

jackey wrote in message <6nju78$slp$1_at_news.seed.net.tw>...
>I use asp connection the ODBC ,
>server response this massage:
>
>Warning: IIS log entry exceeds limit, File /test/testoracle.asp Line 11
>[Microsoft][ODBC driver for Oracle][Oracle]ORA-12641: TNS:authentication
>service failed to initialize
>
>Coule you give a hand ?

[loud applause for anyone foolhardy enough to use ODBC for Oracle]

Logon to NT using the userid in which IIS runs (IIS_USER something or the other) and test SQL*Net connectivity there using TNSPING and SQL*Plus. Oncce you get it working in that userid, Oracle ODBC via IIS should also work. Remember that SQL*Net and ODBC working in the Administrator userid does not mean it will work in any other NT userid on the same box.

regards,
Billy Received on Wed Jul 08 1998 - 05:54:40 CDT