Forum Discussion
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
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
- GilbertQ
Super User
Hi there
Can you confirm you have installed and configured the 64bit version of the ODBC driver on your Gateway server?- adrianohgFrequent 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
Super User
This is how I have got my ODBC Driver set up
"driver=Simba Athena ODBC Driver;dsn=Simba Athena; data source=AwsDataCatalog"