Symptoms
Consider the following scenario:
- You create a connection string by using the Table Import Wizard, and the Use connection string option is selected.
- The user name and password are provided in both the ODBC connection string and the OLE DB connection string.
- You connect to a database by using the Microsoft OLE DB Provider for ODBC Drivers in Microsoft SQL Server 2012 Service Pack 2 PowerPivot for Microsoft Excel 2010 add-in.
- You upload the workbook to a SharePoint PowerPivot Gallery and then set the workbook to update automatically.
In this scenario, the workbook does not update automatically. Additionally, you receive the following error message:
Note
Format of the initialization string does not conform to specification starting at index 59.
Resolution
Cumulative update information
This issue is fixed in the following cumulative updates for SQL Server 2012:
Recommendation: Install the latest cumulative update for SQL Server
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
Latest cumulative update for SQL Server 2012 SP2
Latest cumulative update for SQL Server 2012 SP3
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the terminology that Microsoft uses to describe software updates.