Forum Discussion

adrianohg's avatar
adrianohg
Frequent Visitor
5 years ago
Solved

ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] - Gateway

Hi,

 

I use PowerBI Desktop to connect on my database MySQL with drive ODBC, that´s ok.

 

When configure gateway to connect the data set, I have this error:

 

Falha na última atualização: Wed Sep 23 2020 11:04:06 GMT-0300 (Horário Padrão de Brasília)
Erro durante o processamento de dados no conjunto de dados.Ocultar detalhes
Erro de fonte de dados: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dsn=wamp.codesa.local"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: rel_categoria_cat_consad.
Cluster URI: WABI-BRAZIL-SOUTH-redirect.analysis.windows.net
ID da atividade: 38440beb-fc88-4d32-bafc-2f67477b3910
Solicitar ID: b15e377b-c0a2-f2a4-a838-49f6d84b2395
Hora: 2020-09-23 14:04:06Z

 


Nome da Fonte de Dados/name: odbc_wamp

This is my gateway configuration:

Tipo da Fonte de Dados/type: ODBC
Cadeia de conexão/connection: dsn=wamp.codesa.local

Método de Autenticação/authentication: basic

 

Att,

Adriano Hantequeste Gomes

CODESA/CODFOR

  • adrianohg's avatar
    adrianohg
    5 years ago

    Hi,

     

    I found solution.

     

    I change gateway from my pesonal computer to my server (mysql) and configure the odbc on this server on System DNS.

     

8 Replies

  • Hi there

    Can you confirm you have installed and configured the 64bit version of the ODBC driver on your Gateway server?
    • adrianohg's avatar
      adrianohg
      Frequent Visitor

      Hi,

       

      Yes, a use my desktop with gateway and my odbc drive is 64bits.

       

      I try manual configure my gateway with this dataset:

       

      Driver={MySQL ODBC 8.0 Unicode Driver};Server=wamp.codesa.local;Database=codforv2

       

      It's woks, but i can't liking this gateway with my project. The only gateway display is dataset dsn=wamp.codesa.local

       

      Att,

      Adriano

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        This is how I have got my ODBC Driver set up

        "driver=Simba Athena ODBC Driver;dsn=Simba Athena; data source=AwsDataCatalog"