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?
Solved
How do I setup MSSQL_ADO reader? It is not in my gallery.
Best answer by redgeographics
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?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+22- Contributor
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.
+62- Celebrity
- Best Answer
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?
+1- Safer
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.