Execute permission denied on SP_OACREATE

From: David Brunning (david.brunning_at_dsl.pipex.com)
Date: 08/27/04 

Date: 27 Aug 2004 06:40:26 -0700

I have managed (Not sure how) to do something to corrupt my database,
but I can't seem to identify the corruption using DBCC. The problem I
have is in trying to run an insert query against a table using an
application role.

The error is being trapped through a VB ActiveX but is reproducible in
Query Analyzer. In QA I run this:
------------------------------------------------------------------------------
EXEC sp_setapprole 'KGI', {Encrypt N 'NOTMYPASSWORD'}, 'odbc'
GO

INSERT INTO tblSurveyAttribute (%FIELD LIST%) VALUES (%VALUE LIST%)
GO
------------------------------------------------------------------------------
When I run the insert not using the app role everything is fine, but
when I use sp_setapprole first I get the following error message:
------------------------------------------------------------------------------
Server: Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 61
EXECUTE permission denied on object 'sp_OACreate', database 'master',
owner 'dbo'.
------------------------------------------------------------------------------
Also, if I use a different database the query runs fine with or
without the application role.

I think that the problem started when a nested transaction failed and
my activeX tried to roll back the inner and outer exceptions without
success - I haven't got as far as trying to reproduce how it happened.

Does anyone have any experience of this? Anyone know what the "real"
error message is?

Thanks

Relevant Pages

  • Re: More query questions re: keywords
    ... I left out a closing quote mark in the query after the word "Active". ... As far as your database problem, I am shooting in the dark. ... > & it gave me an error message that I needed. ... > table in Excel (to keep it free from any possible corruption) and imported it ...
    (microsoft.public.access.queries)
  • Re: Is my mdb corrupted ?
    ... If you suspect that a database is corrupt then I suggest that the first ... I have an mdb with the application and an mdb with the ... IS MY MDB CORRUPTED RESULTING IN THESE PROBLEM AND ERROR MESSAGE? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Export Delimited
    ... Database or objects is read-only. ... T558c Table (this is the name of a query) ... My error message: The Microsoft Jet database engine could not find the ...
    (microsoft.public.access.externaldata)
  • Re: Corrupt form...or so it seems
    ... > <The first is you stated that the form is based on a query. ... > the form that I think is corrupt is the Customers Table. ... it just happens to be where the first error message appears ...
    (microsoft.public.access.forms)
  • Re: Corrupt form...or so it seems
    ... <The first is you stated that the form is based on a query. ... the form that I think is corrupt is the Customers Table. ... Already set to break (an error message could very well be popping up ...
    (microsoft.public.access.forms)