Does the component require the DSN? Have you tried using the MSDAORA
provider, instead of MSDASQL?
--
www.aspfaq.com / www.perfhound.com
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3d109d47$0$8505$ed9e5944_at_reading.news.pipex.net...
> 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:08:17 CDT
