Posted by Erland Sommarskog on 08/21/07 21:46

monty (manishgandhi13@gmail.com) writes:
> I am facing a problem while executing a statement through C++ code
> using OLEDB API of Sql server.
> There is a problem with DB_OWNER role. If I will enable the DB_OWNER
> everything is going fine but if I will remove this role than I am
> getting error "DB_E_ERRORSINCOMMAND".
>
> But if I will execute the same in query analyser it is going
> absolutely fine in either case.
> I am not able to understand why I am getting error while using API.

I'm afraid that I need to ask for more information. What do you mean
with "enable the DB_OWNER role"? Do you mean that you add the user
you connect with to the DB_OWNER role?

Do you run with the same user from QA?

Have you examined the ISqlServerErrorInfo object to get the error message?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: An expression of non-boolean type specified in a context where a condition is expected, near ')'.
• Prev in forum: Re: Need help w/ a script
• Thread view: Re: Problem with DB_OWNER role..

[Reply to this message]