Forum Discussion

Sermicro's avatar
Sermicro
Frequent Visitor
4 years ago

DataSource.Error: ODBC: ERROR [S1000] [Cache ODBC][State : S1000][Native Code 417] - Conexión orígen

Hola comunidad, recurro a uds pues ya se me han agotado todas las alternativas y no encuentro solución. Cuando quiero actualizar datos de un informe en donde uno de sus origenes de datos es vía ODBC...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Sermicro ,

According to your description, there may be three reasons, one is the user name and password; the other is the version reason; you can try the following ways:

1.What's the version of ODBC did you create, 32 bit or 64 bit?  if your app is configured for 32-bit (Platform option of x86) and is running under 64-bit Windows, you will need to use the 32-bit Data Sources applet under Administrative Tools in Control Panel to create the DSN. Also, the Oracle Client software must match the platform the app is running under (32 or 64-bit)

 

2.Please verify the User credentials as it would be the case sensitive issue. I suggest to use upper case while you connect to ODBC.

In addition, you could refer this link.

 

3.Your ODBC driver for my database need to update to the lastest.

Similar error refer:

https://community.powerbi.com/t5/Power-Query/ODBC-behavior-error/td-p/93448 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Lucien

Sermicro's avatar
Sermicro
Frequent Visitor
4 years ago

Thank´s for ypur help. I verify everything you mention. I have same drivers. I use same credentials. And the error that you mention is similar but it doesn´t solve my problem. 

  • Sermicro's avatar
    Sermicro
    Frequent Visitor
    4 years ago

    Maybe it´s helps, but when I check drivers connections there are all ok. Thank´s.