Re: Problem connecting Oracle from Windows service

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 11 Feb 2003 15:20:33 -0000
Message-ID: <3e4914c3$0$14163$ed9e5944@reading.news.pipex.net>

"Matthias Meyer" <matthias.meyer_at_softron.de> wrote in message news:b2at5b$1a15lb$1_at_ID-114817.news.dfncis.de...
> Hi newsgroup,
>
> I have a problem connecting an Oracle DB via ODBC from a Windows service.
> The details:
> Our application has a "client" (a normal interactive Windows application)
> and a "server" (a Win32 service). Both are running on the same machine.
Both
> connect to a remote Oracle DB using ODBC. Usually this works fine, but on
> one computer we have a problem: The client connects, but the server won´t.

<snip>
> Any suggestions why the ODBC driver, called by the interactive
application,
> finds the Oracle client, but called by the server application, it does
not?
>
> Versions:
> Windows: NT 4.0
> Oracle: 9.2.1.0.0
> ODBC driver: Microsoft ODBC for Oracle 2.573.9030.00

If you check out the file permissions on your oracle_home directory you will most likely find that the account under which the service runs doesn't have read,list and execute rights to the directory. This happens a lot with asp apps.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Tue Feb 11 2003 - 09:20:33 CST