Re: Need help with connect string for using Application Roles in SQL Server.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jeff Dillon (jeff_at_removeemergencyreporting.com)
Date: 11/10/04 

Date: Wed, 10 Nov 2004 10:35:05 -0800

No, without the proper login, you won't be able to connect to the database
at all.

Have you succeeded in making a connection without using Application Roles?

Also, show your connection string

Jeff

"Ken Varn" <nospam> wrote in message
news:Oj3Ip60xEHA.2012@TK2MSFTNGP15.phx.gbl...
> I am trying to figure out how to do a connection string for a ADO.NET
> SqlConnection object on a database that implements Application Roles. I
> cannot seem to get the connection to work. I am of the impression that an
> initial connection must be made to the database and then the sp_setapprole
> stored procedure must be run to get the proper Application Role permission
> to the database. I cannot get past the Open() method of the connection
> object to get to a position where I can run the sp_setapprole stored
> procedure. Is there some specific connection string that I need to use?
> Please help!
>
>
> --
> -----------------------------------
> Ken Varn
> Senior Software Engineer
> Diebold Inc.
>
> EmailID = varnk
> Domain = Diebold.com
> -----------------------------------
>
>

Relevant Pages

  • Re: [SOLVED] Cannot display provider-specific login prompt
    ... scenario where the program wouldn't have to know about the database, ... ConnectionStringBuilder up to a PropertyGrid for the end user to populate), ... details of the connection, for the sake of the program being able to connect ... information about the connection string that I will need. ...
    (microsoft.public.dotnet.framework.adonet)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: Problems in loading data from an access database into an array
    ... Suppose your database has a table called which has columns called ... Dim oleCSB As New OleDbConnectionStringBuilder ... 'associate the connection string just built with the ole connection ...
    (microsoft.public.dotnet.framework.adonet)