Forum Discussion
ODBC: ERROR [S1000] [Cache ODBC][State : S1000][Native Code 417]
Hello community,
Please help me with the below.
When I want to update a report in Power BI Desktop where one of its data sources is via ODBC and I get the error that I copy below.
ODBC: ERROR [S1000] [Cache ODBC][State : S1000][Native Code 417] [C:\Program Files\WindowsApps\Microsoft.MicrosoftPowerBIDesktop_2.123.742.0_x64__8wekyb3d8bbwe\bin\Microsoft.Mashup.Container.NetFX45.exe] Access Denied
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
Driver installed intersystems ODBC 64 bit
Hi, Aasir2 there can be various troubles that cause this error
please refer to the linked discussion :
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
Below worked for me,
I deleted the data sources in data files DSNs
Deteted DSNs from ODBC data sources
Uninstalled and reinstalled the Intersystems ODBC drivers.
Recreated the DSNs and this worked.
3 Replies
- Aasir2Regular Visitor
Thank you, I already went through this discussion but it didn't help.
- Aasir2Regular Visitor
Below worked for me,
I deleted the data sources in data files DSNs
Deteted DSNs from ODBC data sources
Uninstalled and reinstalled the Intersystems ODBC drivers.
Recreated the DSNs and this worked.