exec sp_Setapprole TMSSQL Midas

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 1
Joined: Tue 07 Apr 2009 10:30

exec sp_Setapprole TMSSQL Midas

Post by peter.nyamu » Tue 07 Apr 2009 10:46

I am using delphi 6 with update pack 2 and sdal, my application uses midas as well my problem is that sp_setapprole on the my appserver does not seem to be working

The statement reads Cmdlogin.sql.add(Format('exec sp_setapprole ?s,{Encrypt N%s},''ODBC'',[qoutedstr(a)],[qoutedstr(b)]))

This was works well with sqlserver 2000 but when i upgraded to sqlserver 2005 i usually get an error about the role does not exist or access denied.

I use TMSConnection and TMssql

Devart Team
Posts: 2888
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 09 Apr 2009 07:03

Please try to execute this stored procedure using TMSStoredProc and check if the problem still exists.

Post Reply