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 me surge el error que copio más abajo. Lo llamativo es que accediendo desde un ordenador de un compañero, con excatamente los mismos drivers odbc, no tiene ningún inconveniente en actualizar los datos. Si me conecto desde excel al mismo origen de datos odbc no tengo inconvenientes. Antes me pasaba tanto en excel como en power bi pero luego de configurar mi ordenador exactamente igual a la de mi colega, ahora solo me sucede en Power BI.

 

Mi query es: = Odbc.Query(Centralita_ODBC, "SELECT * FROM dApplicationStat WHERE Application like '%NOMBRE%' AND ""Timestamp"" < DATEADD(DAY, -" & DiasDetalle & ", CAST(CURRENT_TIMESTAMP AS date)) " )

 

ERROR:

DataSource.Error: ODBC: ERROR [S1000] [Cache ODBC][State : S1000][Native Code 417]
[C:\Program Files\Microsoft Power BI Desktop\bin\Microsoft.Mashup.Container.NetFX45.exe]
Access Denied
ERROR [01000] [Microsoft][Administrador de controladores ODBC] El controlador no admite una versión de ODBC distinta de la que la necesita la aplicación (vea SQLSetEnvAttr).
Detalles:
DataSourceKind=Odbc
DataSourcePath=dsn=CENTRALITA
OdbcErrors=[Table]

 

Desde ya muchisimas gracias de antemano.

 

5 Replies

    • Sermicro's avatar
      Sermicro
      Frequent Visitor

      I read the information of the link. But it doesn´t help. I will write to intersystem. Thank´s.

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support

    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

      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

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