Yes it does appear to require the DSN. Good suggestion for msdaora as I have
tried the oracle oledb provider. unfortunately no joy. I think we will try a
rebuild as this is a test system and I'm not entirely sure the build
procedure was followed now I look closer at the system. Thanks for your
suggestions.
--
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:OI3ygM6FCHA.2444_at_tkmsftngp05...
> 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 Thu Jun 20 2002 - 04:18:48 CDT
