AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Odbc excel driver login failed3/14/2024 ![]() ![]() This issue occurs because the Extended Properties information is not contained in the ODBC connection string. The following is a sample of the connection string that you created: Provider=MSDASQL.1 Persist Security Info=True User ID=sa Initial Catalog=test DSN=MSSQL 2012 Password=********** Reason: ERROR Login failed for user ''.ĮRROR Invalid connection string attributeĮRROR Login failed for user ''. However, when you click Next, you receive the following error message: Failed to connect to the server. You create the connection string by using the Table Import Wizard. SymptomsĪssume that you try to connect to a database by using Microsoft OLE DB Provider for ODBC Drivers in the PowerPivot for Microsoft Excel 2010 or PowerPivot for Microsoft Excel 2013 add-in. For more information about this change, read this blog post. Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. ![]()
0 Comments
Read More
Leave a Reply. |