Connection String SQL Server 2005 With Various Data Provider

The following is a list of database connection strings to use with various Sql Server data providers. Cut and paste the connection string to use within your application. For connection strings that require a servername, username and password.

·    ODBC: 
  • Driver={SQL Server}; Server=your Server name; Database=DBname; Uid=’your uid’; Pwd='your password';  
  • OLE DB, OleDbConnection (.NET):
  • Provider=sqloledb; Data Source= your Server name; Initial Catalog= DBname; User ID=’your uid’; Password='your password';
  • SqlConnection (.NET):
  • Data Source=your server name; Initial Catalog=DB name; User ID=’your uid’; Password='your password';

Prev Post                                                      All Post                                                           Next Post

Posted in |


Post a Comment