|
Home > Archive > MS SQL Server ODBC > April 2005 > Using Application Roles with an ODBC or OLE DB Connection.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Using Application Roles with an ODBC or OLE DB Connection.
|
|
| Peter Berton 2005-04-19, 8:23 pm |
| Does anyone know of an ODBC or OLEDB driver that supports the use of
Application Roles?
I am looking for one so that the Application Role information could be
specified as part of the connection String and the calling app will not have
to make a separate call to set the application role.
We are attempting to implement Application Roles to be used by our Crystal
reports. Crystal calls the ODBC or OLEDB driver to get the data and currently
there is not a way to have Crystal set the Application Role. Thus our need.
--
Peter Berton
Software Engineer
| |
| Mary Chipman [MSFT] 2005-04-20, 9:23 am |
| Application roles always require the client code to supply the name of
the application role and the password in order to be activated; it's
always a post-connection call. IOW, the client must first be
authenticated by the server, and then the approle activated inside of
the database.
Before you jump into using approles, you may want to take a look at
the implications, which are described in the following paper:
SQL application role errors with OLE DB resource pooling
http://support.microsoft.com/defaul...B;EN-US;Q229564
--Mary
On Tue, 19 Apr 2005 12:42:02 -0700, Peter Berton
< PeterBerton@discussi
ons.microsoft.com> wrote:
>Does anyone know of an ODBC or OLEDB driver that supports the use of
>Application Roles?
>
>I am looking for one so that the Application Role information could be
>specified as part of the connection String and the calling app will not have
>to make a separate call to set the application role.
>
>We are attempting to implement Application Roles to be used by our Crystal
>reports. Crystal calls the ODBC or OLEDB driver to get the data and currently
>there is not a way to have Crystal set the Application Role. Thus our need.
| |
| Peter Berton 2005-04-20, 1:23 pm |
| Thanks for the information. We have done a significant amount of research on
implementing Approles, but this piece of info in the article will be a lot of
help.
"Peter Berton" wrote:
> Does anyone know of an ODBC or OLEDB driver that supports the use of
> Application Roles?
>
> I am looking for one so that the Application Role information could be
> specified as part of the connection String and the calling app will not have
> to make a separate call to set the application role.
>
> We are attempting to implement Application Roles to be used by our Crystal
> reports. Crystal calls the ODBC or OLEDB driver to get the data and currently
> there is not a way to have Crystal set the Application Role. Thus our need.
>
> --
> Peter Berton
> Software Engineer
>
|
|
|
|
|