Solved

sql statement

Forum|Forum|10 years ago
September 10, 2015
4 replies
146 views

ariel
3 replies

Hi, all:

I have a huge MS SQL Server Non-spatial database,each record has a "datetime" time stamp. Now I'm using "SQLCreator" to read the data.

In the SQL Statement, I wrote:

SELECT * FROM mytable

WHERE ID='1007'

AND YEAR(datetime)=2015

AND MONTH(datetime)=1

But I cannot get the data and FME say: MS SQL Server Reader: Query failed, possibly due to a malformed statement. Provider error `(-2147217871) Query timeout expired'

Does anyone know the reason?

Thanks in advance,

Ariel

Best answer by fmelizard

FME will set a timeout value by default. If you are encountering this error, you set the Command Timeout to 0 so there is no timeout.

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.