Skip to main content
Question

Issue with DB connection: Incorrect syntax near key word 'WHERE'

  • February 14, 2014
  • 4 replies
  • 55 views
M
Hi everybody

 

I'm pretty new on this community, so please forgive all my mistakes.

 

I have problem with DB connection. I'm using win xp, FME 2014. I have access to DB, but when i'm  trying to connect with db i recived message as you see on image. All settings in FME and ODBC should be correct. On the other machine (win7) where settings are the same , connection issue doesn't exist. Could you give me some advises where the problem is?

 

Best regards Maciek

 

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.

4 replies

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • February 14, 2014
i can't read it well, but do i read where 1=0?
M
  • maciej
  • Author
  • February 14, 2014
Yes, exactly but i don't kow why, because  'WHERE clause:' field is empty.
david_r
Celebrity
  • david_rCelebrity
  • February 17, 2014
Hi,

 

 

I think FME is adding "WHERE 1=0" to read the schema definition without any data. Could very well be expected behavior.

 

 

Sounds like a case for Safe support.

 

 

David
M
  • maciej
  • Author
  • February 17, 2014
Hi David, Myabe, so now Safe support is working on that.

 

Thanks

Community Stats

32,408
Posts
122,908
Replies
40,126
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.