Posted by monty on 08/22/07 07:18

On Aug 22, 2:46 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> monty (manishgandh...@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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

yes by enabling the DB_OWNER i mean giving DB_OWNER role to the user.
And I am running with the same user in QA with which i am connecting
through API.

Also I have examined ISqlServerErrorInfo object to get the error
message because of that only I am getting error DB_E_ERRORSINCOMMAND.

Feel free to ask for more information.....

[Back to original message]