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!!!