SQLXML 4.0 OLEDB Provider connection strings

cslist_top_horizontal

SQL Server 2019

With Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)

The DataTypeCompatibility=80 is important for the XML types to be recognised by ADO.

Provider=SQLXMLOLEDB.4.0;Data Provider=MSOLEDBSQL;DataTypeCompatibility=80;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

See also the other options available for MSOLEDBSQL connection strings.

SQL Server 2017

With Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)

The DataTypeCompatibility=80 is important for the XML types to be recognised by ADO.

Provider=SQLXMLOLEDB.4.0;Data Provider=MSOLEDBSQL;DataTypeCompatibility=80;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

See also the other options available for MSOLEDBSQL connection strings.

SQL Server 2016

With Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)

The DataTypeCompatibility=80 is important for the XML types to be recognised by ADO.

Provider=SQLXMLOLEDB.4.0;Data Provider=MSOLEDBSQL;DataTypeCompatibility=80;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

See also the other options available for MSOLEDBSQL connection strings.

SQL Server 2014

With Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)

The DataTypeCompatibility=80 is important for the XML types to be recognised by ADO.

Provider=SQLXMLOLEDB.4.0;Data Provider=MSOLEDBSQL;DataTypeCompatibility=80;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

See also the other options available for MSOLEDBSQL connection strings.

SQL Server 2012

With Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)

The DataTypeCompatibility=80 is important for the XML types to be recognised by ADO.

Provider=SQLXMLOLEDB.4.0;Data Provider=MSOLEDBSQL;DataTypeCompatibility=80;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

See also the other options available for MSOLEDBSQL connection strings.

Using SQL Server Native Client provider 11 (SQLNCLI11)

Provider=SQLXMLOLEDB.4.0;Data Provider=SQLNCLI11;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

SQL Server 2008

Using SQL Server Native Client provider 10 (SQLNCLI10)

Provider=SQLXMLOLEDB.4.0;Data Provider=SQLNCLI10;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

SQL Server 2005

Using SQL Server Native Client provider (SQLNCLI)

Provider=SQLXMLOLEDB.4.0;Data Provider=SQLNCLI;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;