Application pool equivalent of low (iis process)?

Hello

I'm trying to use an ODBC connection to NotesSQL in an ASP page hosted
on IIS.

I've been having a pig of a time connecting to the database in ASP,
getting the error below, even the same code works e.g. in a vbs script
ran on the server.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on
SQL_HANDLE_DBC failed

Having banged my head against this for a while and fought my way through
the abysmally poor NotesSQL documentation, I have come to thinking that
the problem is that the NotesSQL executable isn't being run in the
expeceted process.

In this IBM technote
(http://www-1.ibm.com/support/docview.wss?uid=swg21095390) it is
suggested that one should "... change your Application Protection to Low
(IIS Process)...".

However in IIS Manager on this server, I don't have this option; instead
I must choose an application pool.

Hence I'm thinking that the application pool is executing as the NETWORK
SERVICE but the page is accessed as IUSR_SERVER and this may be the
problem...

So I've too questions:
* Am I on the right track here?
* What might I do about it?

Many thanks in anticipation of any help on this.

Re: Application pool equivalent of low (iis process)?

To answer your question, there is an option you can run the application pool
using LOCAL SYSTEM. This is in the properties of the application pool, this
could be a security risk. The error you are getting appear to be related
to the permissions accessing the database. Assuming you installed the ODBC
drivers on the web server, I would see if you can manually test connectivity
to the database.

--

Thank you,

Steve Schofield
Windows Server MVP - IIS
ASPInsider Member - MCP

http://www.orcsweb.com/
Managed Complex Hosting
#1 in Service and Support


"BMC" wrote in message
news:u59YKLWDHHA.4060@TK2MSFTNGP03.phx.gbl...
> Hello
>
> I'm trying to use an ODBC connection to NotesSQL in an ASP page hosted
> on IIS.
>
> I've been having a pig of a time connecting to the database in ASP,
> getting the error below, even the same code works e.g. in a vbs script
> ran on the server.
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on
> SQL_HANDLE_DBC failed
>
> Having banged my head against this for a while and fought my way through
> the abysmally poor NotesSQL documentation, I have come to thinking that
> the problem is that the NotesSQL executable isn't being run in the
> expeceted process.
>
> In this IBM technote
> (http://www-1.ibm.com/support/docview.wss?uid=swg21095390) it is
> suggested that one should "... change your Application Protection to Low
> (IIS Process)...".
>
> However in IIS Manager on this server, I don't have this option; instead
> I must choose an application pool.
>
> Hence I'm thinking that the application pool is executing as the NETWORK
> SERVICE but the page is accessed as IUSR_SERVER and this may be the
> problem...
>
> So I've too questions:
> * Am I on the right track here?
> * What might I do about it?
>
> Many thanks in anticipation of any help on this.

Re: Application pool equivalent of low (iis process)?

Steve Schofield wrote:
> To answer your question, there is an option you can run the application pool
> using LOCAL SYSTEM. This is in the properties of the application pool, this
> could be a security risk. The error you are getting appear to be related
> to the permissions accessing the database. Assuming you installed the ODBC
> drivers on the web server, I would see if you can manually test connectivity
> to the database.
>
Thanks, running the application pool as local system works.
Connectivity was never an issue, it was definitely permissions.
I would ideally still like to get this to work in a more secure way,
however none of the related suggestions in IBM's technote make the
slightest difference.