change OLE DB connection type

I'm trying to change to connection type of OLE DB provider, how is this possible?

Hi Kurt,

MS SQL Server repository connection is using 32 bit Microsoft OLE DB Provider for SQL Server by default, it is though possible to use a different Provider by switching to OLE DB Repository connection type.



Create new MS Sql Server repository connection

1. Click Options
2. Click Plus
3. Enter connection name
4. Set type to MS Sql Server
5. Select/Enter server name
6. Enter user name and password
7. Select database name
8. Test the connection

Create new MS Sql Server repository connection using Ole DB

1. Click Options
2. Click Plus
3. Enter connection name
4. Set type to Ole DB
5. Select build connection
6. Select relevant Ole DB provider and enter necessary parameters
7. Test the connection

Note:

• It is recommended to use the latest version of 32 bit MS SQL Server client
• Though not required it is recommended to define the SQL username and password

Source: SQL Server Repository Configuration

I hope this clarifies.