hi<br><br>i have problem when i try insert data in mssql server, when i try run script, just 2 or 3 lines insert ok, but , insert  stop .<br><br>I use pipe, my confs. <br><br>destination d_mssql {<br>    pipe(&quot;/var/mssql.syslog-ng.pipe&quot;<br>
   template( &quot;INSERT INTO logs (host, facility, priority, level, tag, datetime, program, msg ) VALUES ( &#39;$HOST&#39;,&#39;$FACILITY&#39;,&#39;$PRIORITY&#39;,&#39;$LEVEL&#39;,&#39;$TAG&#39;,&#39;$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC&#39;,&#39;$PROGRAM&#39;,&#39;$MSG&#39; );\n&quot; ) template-escape(yes));<br>
  template-escape(yes));<br>};<br><br><br>log {<br>      source(s_all);<br>      destination(d_mssql);<br>};<br><br>my script:<br><br>if [ -e /var/mssql.syslog-ng.pipe ]; then<br>       while [ -e /var/mssql.syslog-ng.pipe ]<br>
                do<br>                    #isql -v MSSQL &quot;syslogng&quot; &quot;h0hYgbDB6Q&quot; &lt; /var/mssql.syslog-ng.pipe &gt; /dev/null<br>                    isql -v MSSQL &quot;syslogng&quot; &quot;h0hYgbDB6Q&quot; &lt; /var/mssql.syslog-ng.pipe<br>
               done<br>else<br><br>        mkfifo /var/mssql.syslog-ng.pipe<br>fi<br><br><br><br>when i try run script: <br><br>./syslog2mssql.sh <br>+---------------------------------------+<br>| Connected!                            |<br>
|                                       |<br>| sql-statement                         |<br>| help [tablename]                      |<br>| quit                                  |<br>|                                       |<br>
+---------------------------------------+<br>SQL&gt; SQLRowCount returns 1<br>SQL&gt; +------------+<br>|            |<br>+------------+<br>+------------+<br>SQLRowCount returns 0<br>SQL&gt; SQLRowCount returns -1<br>SQL&gt; SQLRowCount returns 1<br>
SQL&gt; [ISQL]ERROR: Could not SQLPrepare<br>SQL&gt; [ISQL]ERROR: Could not SQLPrepare./syslog2mssql.sh <br>+---------------------------------------+<br>| Connected!                            |<br>|                                       |<br>
| sql-statement                         |<br>| help [tablename]                      |<br>| quit                                  |<br>|                                       |<br>+---------------------------------------+<br>
SQL&gt; SQLRowCount returns 1<br>SQL&gt; +------------+<br>|            |<br>+------------+<br>+------------+<br>SQLRowCount returns 0<br>SQL&gt; SQLRowCount returns -1<br>SQL&gt; SQLRowCount returns 1<br>SQL&gt; [ISQL]ERROR: Could not SQLPrepare<br>
SQL&gt; [ISQL]ERROR: Could not SQLPrepare<br><br><br><br>someone have idea for this ?<br clear="all"><br><br>-- <br>Bely Silva Junior<br>