To homepage To homepage
Solved

Azure Data Factory - SQL Server (14.0.0.0) was not found

  • 25 April 2024
  • 3 replies
  • 24 views
Paul McLeod Bespoke Analytics
Rank
Badge

Hi I am trying to use ADF to connect to a on-premise SQL Database with some very large tables for transfer.

I selected the Azure Data Factory - SQL Server (14.0.0.0) as the source and created the datasource.

When I tried to Synchronize the ODX source in TX desktop (6521.1) I got the error message that the assembly for the provider is not installed.

I cannot change the provider without creating a new data source (product enhancement request!), Do I need to upgrade the TX Desktop to get access to the drivers? Or is it some other install that I need to do? I cant find any documentation on this.

icon

Best answer by Thomas Lind 29 April 2024, 11:19

View original

3 replies

rory.smith
Rank
Userlevel 5
Badge +7

Hi @Paul McLeod Bespoke Analytics ,

do you have SQL Server Management Studio installed on your ODX machine / TX machine? It could be you are missing the client drivers for SQL Server on your ODX machine. If you are using a Self-hosted Integration Runtime and that is on a different machine, then that machine may be missing client drivers.

In most cases SQL Server Management Studio covers all the driver bases, but you may need to install separate drivers if you are connecting to (much) older or newer SQL Server versions. If that doesn't solve it, a screenshot of the error would probably narrow things down a bit.

Thomas Lind
Rank
Userlevel 6
Badge +5

Hi @Paul McLeod Bespoke Analytics 

If you look in the following folder, what versions do you have there?
C:\ProgramData\TimeXtender\ODX SaaS\Components\DataFactorySource\Azure Data Factory - SQL Server

You are supposed to only have 14.0.0.0. But if you have none it would explain the error.

Paul McLeod Bespoke Analytics
Rank
Badge

Thanks Thomas,

I do have the 14.0.0.0, I just selected the most current version when creating the datasource, because why not!

I did try using the lowest version (11) and it kind of worked but I kept getting some synchronization errors.

I have now switched to 14, appears to be working correctly now, just testing a 4 hour load!

I think I am all set now. might be a nice feature to be able to change the version on an existing datasource up or down without having to create a whole new datasource.

Reply


Terms and ConditionsCookie settings