>Have any of you guys used application roles in SQL server 7. I have set up an application role, but how do I access it through Fox ODBC. Each time I set up the ODBC and enter the a roles name and password I get a login error. So I have can't set ODBC up to access SQL.
>
>If anyone has done this, please let me know!!!

You need to log in as a user. In SQL Server, you would grant the role to the user. When the user logged via ODBC as the appropriate user, the access permissions granted to that role would be available.

HTH.