DataSource.Error: ODBC: ERROR [HYC00] [Microsoft][ODBC Driver Manager] Driver does not support this parameter

Question

_{Thursday, May 2, 2019 8:54 AM}

Hi

I'm trying to use Microsoft BI but failing to get a connection for the above error - any suggestions please

thanks

All replies (2)

_{Thursday, May 2, 2019 9:23 AM}

Hello,

The error code is indicating a feature that you are attempting to use is not supported as per the following page search for HYC00. With that the best avenue is to not use ODBC but use SqlClient data provider instead.

/en-us/sql/odbc/reference/appendixes/appendix-a-odbc-error-codes?view=sql-server-2017

Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.

NuGet BaseConnectionLibrary for database connections.

StackOverFlow

_{Saturday, January 18, 2020 2:45 AM}

What worked for me when I came across this error was going to Data > Get Data > From Other Sources > From Microsoft Query instead of choosing From ODBC.

I also made the change within QB to allow external sources to connect as the admin user. You must be logged in as the admin user and in Single User Mode. Edit > Preferences > Integrated Applications > Company Preferences > (Application Name) Properties > Select Admin.