On Windows, the ODBC.INI information is stored in the registry. The ODBC.INI keyword in the Keyword column can be set at the data source name (DSN) level in the ODBC.INI file. By visiting our website with your browser set to allow cookies, you consent to our use of cookies as described in our Privacy Policy. The name of the database server is stored in the ServerName variable, the name of the database is held in the DBName variable.The function starts by reading those two values from the registry (using the custom ReadRegistry() procedure).Once the ConnectionString is assembled, we simply call then AdoConn.Open method. The Connection String keyword in the Keyword column can be used on the connection strings passed to SQLBrowseConnect and SQLDriverConnect.

This website uses cookies to provide you with the very best experience and to know you better. Initial Catalog The name of the Database. Data Source The name of the SQL Server and its Instance. Net native SQL data provider rather than using OleDB connection string. SQL Server Connection String for SQL Server Authentication is defined as follows and it consists of the following properties.

You do not need to specify username and password if your Microsoft Access database is not password protected.įollowing is the sample connection string for Microsoft SQL server (using OleDB connection): 'Provider=sqloledb Data Source= Initial Catalog= User Id= Password='įor ASP.Net application, you should consider using the. Instead of providing full path of your Microsoft Access database, you can use Server.Mappath function as well. For example, an OLE DB connection manager that connects to Microsoft Access database or SQL Server can use the Microsoft Access Jet or Microsoft OLE DB Provider for SQL Server.įollowing is the sample connection string for Microsoft Access (Jet OleDB): 'PROVIDER=.4.0 DATA Source= User ID=Admin Password=dbpassword' An OLE DB connection enables to connect to a data source by using an OLE DB provider.

Sql server connection string