|
anju wrote:
for different UserIds and Passwords the connection string is always different
Yes it is, but, then you don't use different user IDs/passwords in your application. If your application needs logins, you create a table in your database with the user name and passwords *for your application*.
Then you create one single SQL Server user that only has access to run stored procedures on your application's database. This is the user ID you use everywhere in your application to access your database (of course, you must have stored procedures to access all tables.)
When a user logs in your application, you find out in your database using the stored procedures what permissions that user has, and selectively enable/disable parts of your application.
But you only should have one database user ID/password, and use that in your connection string (never sa). This way, all the connection strings will be the same, and connection pooling will work fine.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
|
I'd agree with that in general, but there are times that it's not practical, for example if you have a service that's running as SYSTEM with the database on another machine. Yes, I know that it's bad practice to have a service running as SYSTEM unless absolutely necessary - unfortunately this is a legacy service with UI and therefore has to run as an interactive service, hence it has to run as SYSTEM.
It's useful to note that you don't need a domain to set this up, but if you don't have one, you'll need to create user accounts for the appropriate users on the server hosting SQL Server, and add them to SQL Server's logins. You then need to synchronize the passwords for those user accounts between the machine that the client runs on and the server hosting SQL.
One thing you can do with Windows Authentication that you can't with SQL Server Authentication is to set up groups of users with particular permissions.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
|
Colin Angus Mackay wrote:
Actually, I'd use windows authentication
Well, yes. But if he were using Windows Authentication, then he wouldn't be having problems with different connection strings: it would always be the same. But still, Mike's reply shows some situations where it isn't practical. In my current application, there's Windows Server with a MSDE and several other machines accessing it. The network is not configured with a domain, so its easier to just use sa with a blank password.
Just kidding, I have a SQL server user with limited permissions and I use SQL login info and store the connection string encrypted. 
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
I want to zip files using a freely available Zip component which is available for download from the below address
http://www.xstandard.com/page.asp?p=C9891D8A-5390-44ED-BC60-2267ED6763A7&ss=D6DD5252-781D-47AE-900A-29F56BB7DFFE
The Following is the way i'm trying to zip the file but i m not able to Zip the file and save it
Please help me.
DECLARE @Result int, @Zipper int, @FileID int ,@source varchar(255), @description varchar(255)
execute sp_OACreate 'XStandard.Zip', @Zipper OUT
execute @Result = sp_OAMethod @Zipper, 'Pack', @FileID,'c:\\helloSQL.txt','c:\\wilbur.zip',true,9
Regards
Wilbur J. Pereira
"If they love me let them, for the heck of it.If they don't, who da heck cares about it"
|
|
|
|
|
|
I am creating a ASP.NET web application that allows users to execute DTS packages stored on the server. IIS has integrated windows authentication enabled. When the user executes the DTS package, I need the package to use the user's windows account to connect to the database. I have enabled integrated security, and according to the log file created when the DTS package is executed, my windows username is captured as the user who executes the package, but the database connections are made with the ASPNET account. How would I get the DTS package to use windows authentication? 
Thanks.
|
|
|
|
|
I have read your Article Edit Almost Anything in a datagrid -Declan Brennan.
which is very interesting and a challenging work. My good wishes for your work.
I like to have in depth knowledge on it. Can you please help me?
I like do it in my project Address book for an Hospital in my hometown.
Traversing by Department Name and viewing patient Address in an datagrid.
Loading all patient Pictures and differentiating their disease using color box.
How to place the picure and colorbox ?
Profile
Name :Uma V
Qualification : M.c.a
Currently doing a DOT Net course and implementing a project in c#
Please give me your hand in making my project a success.
Regards
|
|
|
|
|
Hi,
In the database I have a table named
Equipment_Master(EqptNo, Eqptname, EqptDesc,ParentEqpt). In this table the parenteqpt is the any EqptNo from the same table. I want to show this data in the Treeview control(as a Parent Child relation) in Asp.Net. How can I do this.
Regards
Kalayn
|
|
|
|
|
Hi to Everybody!
I’ve got such problem. I have DataTable and I need to save it in dbf file. I need create .dbf file and then save DtataTable’s contents there.
|
|
|
|
|
|
Thank you, Marek, everything is OK now
|
|
|
|
|
Hi all
I just want to know whether new tables can be created in a SQL Server database at runtime.
I tried the following in Transact-SQL:
CREATE PROCEDURE sp_CreateTable
@TableName VARCHAR(20)
AS
CREATE TABLE @Tablename
(
TableIndex INT NOT NULL
)
It seems it is not happy with using a variable as table name
Any ideas?
Thanks.
Kobus
|
|
|
|
|
kbalias wrote:
I just want to know whether new tables can be created in a SQL Server database at runtime.
Yes.
kbalias wrote:
It seems it is not happy with using a variable as table name
You cannot create a table in this way. The table name cannot be substituted with a variable name.
kbalias wrote:
Any ideas?
Build some dynamic SQL and use EXEC(@SqlStatementString)
However, you must be careful with this as the @TableName variable would have to injected into the SQL statement and that could be a source of a SQL Injection attack.
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
how to search for a specific record in a database using a Button on vb.net?
|
|
|
|
|
What are you trying to do here?
PsYcHo_A wrote:
search for a specific record in a database using a Button
<italic>Work hard, Work effectively.
|
|
|
|
|
Well... you first have to create a project, add a form, add a button to that form, and then write some code. At the same time you need to create a database, some tables, columns, and add some rows to them. 
Now seriously, what is it that you are having trouble with? your question is very very broad. Is it with connecting to the database? the query to find certain recrds? reading the records? displaying them? We are here to help, but we need more details.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
I am a littlebit puzzeld. In all de examples i see to display records from a database there is use of datagrid. But datagrid places all the content of a database in a table.
But i would like to do it de old fasioned way en get every item from a single record to be placed somwhere on a page. So after getting a record this way:
Dim getCmd As String = "select * from Peuters where pnummer=Pnummer"
Dim ksDataAdapter As SqlDataAdapter = New SqlDataAdapter(getCmd, KSConn)
Dim dsPeuters As DataSet = New DataSet()
ksDataAdapter.Fill(dsPeuters, "Peuters")
how do i proceed from there. I cant find anything sim on the web ore the asp.net bible or my Englisch is not that good.
|
|
|
|
|
gharryh wrote:
But datagrid places all the content of a database in a table.
The datagrid uses a DataSet, that is filled with the result set of some SELECT command(s) - not the database.
gharryh wrote:
But i would like to do it de old fasioned way en get every item from a single record to be placed somwhere on a page
I don't quite understand your request, but if you mean getting one row at a time from the database, then you can use a SqlDataReader (assuming your DB is SQL Server)
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
Thanks but ow do i access the valuas from dataset and place then into a HTML table for example RoepnaamdatabaseTableRoepnaamI cant find any info on how the syntax schould be.
|
|
|
|
|
If you want to use a dataset - and if you are going to access the information on a row by row basis then that is quite inefficient, I suggest you use a DataReader - then you can use something like this:
object value = MyDataset.Tables[0].Rows[rowIndex][columnNameString] replacing the rowIndex and columnNameString with appropriate values.You can also loop over the rows like this
foreach(DataRow row in MyDataset.Tables[0].Rows)
{
object value = row[columnNameString];
}
Once you have the value from the column you can do what ever you need to do with it. Like, for example, insert it in to the HTML you are building.
Does this help?
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
I wanted to display a single record on a page where the information is placed on sevreral places on that page. The last question is how the code looks like displaying a certain value from a record from a table.
I know how to do that in PHP but it wont work in .NET
|
|
|
|
|
|
well i'm using for frontend vb.net and for backend sql server 2000. there is table name "employee". in the employee table "empId" and "Password" columns are two things.empID is categorized in to type that "Operational Dept and customer Dept" using frontend i've created a system called "login in to main page" when a employee log into system, the empId sould verify his password also. if the empID and password correctly verified then the employee can login to system, here a operational Dept emp has full permission, but others would some permissions. here y question is how solve this problem. pls kidly help me. thank you very much for your kindly help. pls email me the answer...sadikshaf@yahoo.com
Mohamed Sadik
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
