Execute Permission Denied

[Guest_imported]

I am trying to connect to the database and retrieve some records using Pro*C. Previously i used to connect to Sybase, now i need to connect to MS SQL Server. When i tried to do so, i am getting the below shown error message:

SQLCODE =-229 SQL State 42000
SQL Server Error in command : Create
Execute Permission denied on object 'xxxxx'

But when i tried the same query using a query analyzer ( with the same userid,password and database) i got results.
I dont know why is this not working with my Pro*C program.
What should i do now, any suggestions

Thanks
Tommy

 

[foxdev]

It could be that you are connecting using NT security (trusted connection) using QA, but using standard login when using Pro*C. IOW, you effectively are connecting as two different users, each with their own permissions. Robert Bradley

http://www.foxdev.com/

Do you have too much money? Visit

http://www.agrainofhope.org