SQL Server 2000 (Application) Role accessed through ADO.NET
From: Shri (subsandnews_at_hotmail.com)
Date: 05/09/03
- Next message: Jason: "Re: Transfering NT logins"
- Previous message: Mandar Naik[MSFT]: "Re: SQL Server 2000 (Application) Role accessed through ADO.NET"
- In reply to: Shri: "SQL Server 2000 (Application) Role accessed through ADO.NET"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 9 May 2003 07:21:27 -0700
I should have done this before. I searched
for "sp_setapprole" and found the answer sent by Mr. Darko
Grujic on 3/28/2003 11:20:52 PM (Thank you Sir). The link
you mentioned...
http://support.microsoft.com/default.aspx?scid=KB;EN-
US;Q229564
...helped me.
All I had to do was put "Pooling=False" in my connection
string. Now with this I am able to execute N number of SQL
statements. Now the question is will I be able to execute
a couple of INSERT or UPDATE statements within a
transaction of the Connection object using sp_setapprole
in the method I mentioned?
"Darko Grujic" <darkogrujic@hotmail.com> Sent: 3/28/2003
11:20:52 PM
>-----Original Message-----
>Hello World,
>
>My goal is to use windows authentication only but stop
>users from connecting to SQL Server through other
MSOffice
>tools (like MSAccess link tables) and manipulate data in
>the database.
>
>The database role (Application role) claims to answer my
>question and give only applications access to the
database.
>
>I created a method which takes in an SQL statement as a
>parameter and execute it. So inside the method....
>
>1. I establish the connection to the database
>using "Integrated Security" (for windows authentication)
>through the Connection Object of ADO.NET
>
>2. I execute sp_setapprole stored procedure (providing
the
>app role name and password that has already been created
>on the database I am trying to access).
>
>3. Then I execute the SQL statement passed to the method
>using the command object's ExecuteReader method and store
>the output in a DataReader.
>
>4. I close the connection and return the contents of the
>DataReader.
>
>With the above approach, only one SQL Statement executes.
>As soon as I call the method for the second time, the
>method fails when it is trying to execute the
>sp_setapprole. I get a "General network error. Check your
>network documentation" error.
>
>One other observation : When I don't close the connection
>or dispose it, I am able to execute the method for only
>nine times. The tenth time the method is called, I get
the
>same error.
>
>My need is that I should be able to call the method any
>number of times (that is to call sp_setapprole before I
>execute my SQL statement).
>
>My development environment is VB.NET on .NET Framework
1.0
>and SQL Server 2000. The underlying operating system is
>Windows 2000.
>
>Any ideas somebody.... anybody.... HAAAAALP!!
>
>In advance, I thank you for your help. Also I thank all
>those intelligent grey cells for the time and energy they
>spent to understand the problem and worked towards the
>solution :)
>
>.
>
- Next message: Jason: "Re: Transfering NT logins"
- Previous message: Mandar Naik[MSFT]: "Re: SQL Server 2000 (Application) Role accessed through ADO.NET"
- In reply to: Shri: "SQL Server 2000 (Application) Role accessed through ADO.NET"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
