exec sp_Setapprole TMSSQL Midas
Posted: Tue 07 Apr 2009 10:46
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
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