Unable to connect to Firebird DB with ODBC (DMTS_PublishDatasourceToClusterErrorCode)

[Anonymous]

Hey,

I have one machine where PBI Desktop is installed and is used for development.

This machine has an ODBC configured to connect to a different server that runs Firebird.

PBI Desktop is working well and I am able to connect to the DB.

When I am trying to connect with PBI Service and configure the gateway, I am failing to do so.

I have the gateway installed on the Firebird server as well as the development server.

Error:

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Activity ID:	c7cd0466-c9cb-4aaf-9145-4476c261b706
Request ID:	62eb7450-8b3a-9128-a98c-d18a3f2fb611
Cluster URI:	https://wabi-australia-southeast-redirect.analysis.windows.net
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Tue Apr 02 2019 15:38:28 GMT+1100 (Australian Eastern Daylight Time)
Version:	13.0.8960.148

CDS:	Unable to connect to the data source undefined.
Underlying error code:	-2147467259
Underlying error message:	ODBC: ERROR [08004] [ODBC Firebird Driver]Unable to connect to data source: library '\\server2\c$\Program Files\Firebird\Firebird_2_5\Bin\fbclient.dll' failed to load
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:	Odbc
Microsoft.Data.Mashup.ValueError.DataSourcePath:	dsn=firebird_64
Microsoft.Data.Mashup.ValueError.Reason:	DataSource.Error

Troubleshoot connection problems

Thanks a lot!

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

According to another sloved thread "schedule refresh using ODBC (Firebird driver) and Data Gateway"

The following should be helpful.

Firstly, please create a System DSN to points to your data source, then add the ODBC data source under gateway. 
Secondly, follow the guide in this similar thread to add your ODBC data source within on-premises gateway, then check if you can refresh your dataset. 

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[Anonymous · Accepted solution]

Hi,

I had an issue with my ODBC configuration.

It was an issue like a typo or something silly like that.

So, there wasnt any real issue after all.

Thanks

A

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

According to another sloved thread "schedule refresh using ODBC (Firebird driver) and Data Gateway"

The following should be helpful.

Firstly, please create a System DSN to points to your data source, then add the ODBC data source under gateway. 
Secondly, follow the guide in this similar thread to add your ODBC data source within on-premises gateway, then check if you can refresh your dataset. 

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.