Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Incorrect syntax

Author  Topic 

byronp2
Starting Member

1 Post

Posted - 2009-06-10 : 10:24:26
Hi

We are sending alarms from InTouch Version 8.0 using wwalarmlogger.exe to our SQL Server 2000. Lately this has stopped working and we are unable to find out why. We talked to Wonderware people and the say that the problem is as follows

Unclosed quotation mark before the character string ',0.000000,0.000000,',2)'. Line 1: Incorrect syntax near 'BRIEN'

Does anyone know what this means.

Thanks

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-06-10 : 10:28:48
we need to see the T-SQL that is being executed. Taking a guess, the vendor app is building some dynamic sql and is missing either an opening or closing quote.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -