exec sp_Setapprole TMSSQL Midas

[peter.nyamu]

I am using delphi 6 with update pack 2 and sdal 3.00.0.2, 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

[Dimon]

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