Application Role 
Author Message
 Application Role

Any idea??

A CR 7  call by VB application using a SQL2000 database with
application role.  How to use
this connection?  When i call the report an error "Access
denied to XXX table" occurrs.

Thanks



Mon, 10 Nov 2003 19:42:01 GMT  
 Application Role
Add ";APP=RollName" to your connect string.  Also include the password if
needed for your application roll.


Quote:
> Any idea??

> A CR 7  call by VB application using a SQL2000 database with
> application role.  How to use
> this connection?  When i call the report an error "Access
> denied to XXX table" occurrs.

> Thanks



Sun, 16 Nov 2003 07:57:52 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Using SQL Server Application Roles in a VB.NET web app

2. Invoking an application role

3. sql application roles and crystal reports

4. Application role error

5. SQL Server Integrated login & application Roles

6. SQL Server Application Roles

7. Application Role problems with Crystal Report

8. Problems using SQL Server application roles (long)

9. Activate SQL Application Role with VB6.0

10. application role

11. SQL Server Application roles and connections

12. SQL Server Application Role

 

 
Powered by phpBB® Forum Software