Skip to main content
Question

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

  • February 14, 2014
  • 4 replies
  • 13 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

 

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

Reply


Helpful Members This Week

Community Stats

31,315
Posts
118,741
Replies
38,900
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.