Snort mailing list archives
RE: MS SQL 2000 database setup for snort with snortdb-extra (osql syntax issues?)
From: "McCash, John" <John.McCash () andrew com>
Date: Tue, 27 Apr 2004 13:20:22 -0500
Tod, Yup, that took care of that one all right. Now if someone can just help me with making SQL Server 2000 accept logging requests from the ODBC plugin... Thanks lots John -----Original Message----- From: snort-users-admin () lists sourceforge net [mailto:snort-users-admin () lists sourceforge net]On Behalf Of todb () planb-security net Sent: Tuesday, April 27, 2004 12:48 PM To: McCash, John Cc: snort-users () lists sourceforge net Subject: Re: [Snort-users] MS SQL 2000 database setup for snort with snortdb-extra (osql syntax issues?) John McCash wrote:
The issues seem to be with the escaped apostrophe, the colon, and the use of the word 'Manager'. Does anyone know the proper way to structure these lines for mssql?
In Microsoft SQL 2000, use two apostrophes to represent a literal apostrophe, like: 'Plus Five''s MUMPS'. (Unlike MySQL, backslashes won't work.) There shouldn't be any problem with any other character or phrase, provided it's all contained in apostrohpe delimiters. Fix that and your other problems should disappear. -- Tod ------------------------------------------------------- This SF.net email is sponsored by: The Robotic Monkeys at ThinkGeek For a limited time only, get FREE Ground shipping on all orders of $35 or more. Hurry up and shop folks, this offer expires April 30th! http://www.thinkgeek.com/freeshipping/?cpg=12297 _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users ------------------------------------------------------------------------------------------------ This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any unauthorized use of this email is prohibited. ------------------------------------------------------------------------------------------------ [mf2] ------------------------------------------------------- This SF.net email is sponsored by: The Robotic Monkeys at ThinkGeek For a limited time only, get FREE Ground shipping on all orders of $35 or more. Hurry up and shop folks, this offer expires April 30th! http://www.thinkgeek.com/freeshipping/?cpg297 _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users
Current thread:
- RE: MS SQL 2000 database setup for snort with snortdb-extra (osql syntax issues?) McCash, John (Apr 27)