Connection string Parameter

Home >> Dot Net Interview Questions >> Mix Dot Net Questions

Posted on May 18th , 2009 by Admin

Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\Northwind.mdbParameters in a Connection String - The parameters depends on which data provider is being used.

Server - The name of the SQL Server we wish to access. This is usually the name of the computer that is running SQL server. We may use "local" or "localhost" for local computer. If we are using named instances of SQL server, then the parameter would contain the computer na

me, followed by a backslash,followed by the named instance of the SQL server.

Database - The name of the database we want to connect to.

User ID - A user ID configured in the SQL Server by the SQL Server administrator.

Password - The password associated with the user ID used.

Note that connection string can also contain the Windows NT account security settings. This is done very simple, by passing the paramater "integrated security=true".