Skip to main content
To homepage To homepage
Solved

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

Paul McLeod Bespoke Analytics
TimeXtender Xpert
Forum|alt.badge.img+2

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.

Best answer by Thomas Lind

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.

View original
Did this topic help you find an answer to your question?

3 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • rory.smith
  • TimeXtender Xpert
  • 662 replies
  • April 26, 2024

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.

Christian Hauggaard
1 person likes this
  • Christian Hauggaard
    Christian Hauggaard
Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1035 replies
  • Answer
  • April 29, 2024

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
TimeXtender Xpert
Forum|alt.badge.img+2

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


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings