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 a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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 a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.
+19- 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.
+48- 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
davideagle wrote:
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.
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.