Very Computer

Jim

--
Wayne Snyder MCDBA, SQL Server MVP
Computer  Education Services Corp (CESC), C*te, NC
(Please respond only to the newsgroups.)

PASS - the definitive, global community
for SQL Server professionals - http://www.veryComputer.com/

Quote:> I have an web application in which I am using SQL
> authentication.  The application requires portions of the
> data access to be protected by login.  In these cases, I
> was hoping to use something silimar to the ODBC options I
> have used for Oracle, AS400, etc, which allow an option
> setting in the connectino string stipulating how to
> handle connections with insufficient login info, i.e.
> prompt always, never prompt, prompt if insufficient info,
> etc.  In other words, let SQL take care of prompting for
> login if necessary. I am using VB.NET to develop, and
> have not yet found an equivalent method of doing this.
> Has anyone else done this?  Am I taking the wrong aproach
> with this new technology?  Thanks in advance.

> Jim

Quote:> I have an web application in which I am using SQL
> authentication.  The application requires portions of the
> data access to be protected by login.  In these cases, I
> was hoping to use something silimar to the ODBC options I
> have used for Oracle, AS400, etc, which allow an option
> setting in the connectino string stipulating how to
> handle connections with insufficient login info, i.e.
> prompt always, never prompt, prompt if insufficient info,
> etc.  In other words, let SQL take care of prompting for
> login if necessary. I am using VB.NET to develop, and
> have not yet found an equivalent method of doing this.
> Has anyone else done this?  Am I taking the wrong aproach
> with this new technology?  Thanks in advance.

> Jim