We are using msdasql and the mdac version is 2.7. Sadly the connection
string gets wrapped up in a com component provided by the supplier. The test
connection button they supply returns a success message though so I believe
the string to be correct. as i say the app does work if the account has
admin privileges and not otherwise. The dsn in use is a system dsn.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Aaron Bertrand [MVP]" <aaronATaspfaq.com> wrote in message
news:en9g6z5FCHA.2552_at_tkmsftngp05...
> Are you using the MSDAORA provider? Is it a recent version? What does
your
> connection string look like? What code are you trying to use?
>
> --
> www.aspfaq.com / www.perfhound.com
>
>
>
>
>
>
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3d108fdd$0$8507$ed9e5944_at_reading.news.pipex.net...
> > I have a problem with a vendor supplied asp app which uses the Oracle
ODBC
> > drivers. This app runs fine when the anonymous win2k account is a member
> of
> > administrators but fails when the account is removed. I know therefore
> that
> > this is a permissions issue. I wondered if anyone had come across this
> > sissue before and so would know which permissions to set
> >
> >
> > the error is
> >
> >
> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> >
> > Specified driver could not be loaded due to system error 5 (Oracle in
> > OraHome9i).
> >
> > /helptest/login.asp, line 9
> >
> >
> >
> >
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
> >
> >
>
>
Received on Wed Jun 19 2002 - 10:03:35 CDT
