I am just trying to read from an MS SQL Server non-spatial database, but the reader is not available in my list. I am fairly new to FME and cannot find the reader described in the documentation as "MSSQL_ADO". I have "MSSQL" but it doesn't allow me to enter parameters. What am I missing?
Page 1 / 1
Do you mean this one:
If so are you using the correct spelling for the Reader?
If you are the only other thing I can think of is is, have you installed either the Linux or Mac version of the FME Installer? If so, MS SQL Server is not a supported format to either read or write on those platforms, you'll have to switch to a Windows 32bit or 64bit installer.
According to the documentation the MSSQL_ADO reader requires the SQL Native Client 2008 or 2012, can you doublecheck whether that's on your machine?
Do you mean this one:
If so are you using the correct spelling for the Reader?
If you are the only other thing I can think of is is, have you installed either the Linux or Mac version of the FME Installer? If so, MS SQL Server is not a supported format to either read or write on those platforms, you'll have to switch to a Windows 32bit or 64bit installer.
The JDBC variant is however available on all platforms, and (ignoring spatial) is nearly as feature rich.