Access and SQL Server Application Roles

J

jerryk

Hi,

We are trying to upsize an application and had another issue arise. The SQL
DBA want to use SQL Server Application roles. I was wondering what sort of
changes we need to make to the application. We connection to the SQL
database in 3 ways.

1) We use Pass through queries where the ODBC connection is a part of the
Query defintion.
2) We use dynamic SQL statements via ADO against the database
3) We use linked tables.

Any thoughts or pointers?

jerry
 
B

Brendan Reynolds

I don't have any personal experience of using application roles, but I
stumbled across the following KB article, which I'm afraid doesn't sound
very promising. It seems you have to disable connection pooling when using
application roles via ADO ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q229564

The article mentions SQL Server 7 and 2000, it hasn't been updated to
indicate whether the problem still exists with SQL Server 2005 or not.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Anyone using application roles 4
SQL Application Roles (How to?) 2
Access Frontend to SQL database 2
Pass-Through Query SQL Security 3
Access front-end and SQL Server back-end table lock 2
MS Access 2010 Web Application with SQL server 0
Opinions on SQL Server upsize 13
32 bit access application and 64 bit SQL 2008 2

Top