Re: Query not working in ASP

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 24 Sep 2002 20:16:47 GMT
Message-ID: <3D90C823.5DB46DC1@exesolutions.com>

Prasad Ajinkya wrote:

> Hi all,
> I am working on a win nt machine using IIS and have an Oracle 8 server
> running, now the problem is that in my asp pages i m running a few
> queries which when directly run on SQL*PLUS prompt work perfectly fine
> but when i try to acquire the same results via a recordset i m getting
> various errors. Could anyone help me with this?
>
> Thanx in advance.

And, without ever seeing the schema or the code, you would like us to guess at what those error are?

I guess the problem is that your privileges are granted through roles rather than directly to the connected user.

How close did I come?

Daniel Morgan Received on Tue Sep 24 2002 - 15:16:47 CDT