Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Unable to connect to Firebird DB with ODBC (DMTS_PublishDatasourceToClusterErrorCode)

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



2019-04-02 15_44_55-Window.png

 

Thanks a lot!

2 ACCEPTED SOLUTIONS
v-juanli-msft
Community Support
Community Support

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.

View solution in original post

Anonymous
Not applicable

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

View solution in original post

3 REPLIES 3
v-juanli-msft
Community Support
Community Support

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
Not applicable

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
Community Support
Community Support

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors