Question

Microsoft SQL server Spatial reader failing

  • 16 July 2020
  • 6 replies
  • 108 views

Microsoft SQL Server Spatial Reader now fails to connect post upgrade to 2020.1. It worked with 2020.0. We are getting this error: Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'. - is there something we need to install?


6 replies

Userlevel 2
Badge +12

Just a thought:

Are both 32 or 64 bits?

The bits of the FME install have to match the SQL Server client components.

Badge +8

Same problem here. Worked this morning, broken this afternoon after upgrading to 2020.1.2. Haven't dug in yet to find out about bitness. Later: actually this isn't a problem for our script. Yes the warning is there, but the next line is "Microsoft SQL Server Non-Spatial Reader: Trying to connect using SQL Server 2012 Native Client...", and that succeeds.

 Now to see if we can reverse the try order, or just tell it to not try OLE DB at all.

Badge +2

Same here upgrading from FME Server 2017 to FME Server 2020.2.0.0

Badge

Did anyone ever find a resolution for this?

Badge

Did anyone ever find a resolution for this?

I installed this and now the workspace is working.

 

https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15

@wjloy​ 

 

Did you have to install both 64 and 32-bit versions?

Reply