|
Site Search
Displaying results 1 - 10 of 18 matches (0 seconds)
1.
HOW TO: Log to a MS SQL database using V8.3.2 and above - Kiwi Enterprises
we have choosen to use the SQL Native Client...From the Connection tab specify the location of your MS SQL server. We have simply entered the IP address is this case. Once specified choose the initial database (catalog) that you wish to connect
http://www.kiwisyslog.com/index.php?option=com_kb&page=articles&articleid=171&Itemid=244 - 34.9kb
2. HOW TO: Log to a MS SQL database when using V8.3.1 and below - Kiwi Enterprises HOW TO: Log to a MS SQL database when using V8.3.1 and below This article only applies if you are using Kiwi Syslog Server v8.3.1 or below. Later version users should click here for the information they require. The database options are
http://www.kiwisyslog.com/index.php?option=com_kb&page=articles&articleid=48&Itemid=244 - 34.4kb
3. Action - Log to Database text MSGTEXT Memo 1024 SQL database (Microsoft SQL and generic SQL) Field Name Type Size Date MSGDATE DateTime 10 Time MSGTIME DateTime 8 Priority MSGPRIORITY VarChar 30 Hostname MSGHOSTNAME VarChar 255 Message text MSGTEXT VarChar 1024 MySQL
http://www.kiwisyslog.com/help/syslog/action_log_to_odbc_database.htm - 19.0kb
4. Action - Log to ODBC database text MSGTEXT Memo 1024 SQL database (Microsoft SQL and generic SQL) Field Name Type Size Date MSGDATE DateTime 10 Time MSGTIME DateTime 8 Priority MSGPRIORITY VarChar 30 Hostname MSGHOSTNAME VarChar 255 Message text MSGTEXT VarChar 1024 MySQL
http://www.kiwisyslog.com/help/syslogd7/action_log_to_odbc_database.htm - 27.4kb
5. Custom DB formats the commands. Example of SQL commands: Database type: MySQL database Database name: New Format SQL command to create the table: CREATE TABLE Syslogd (MsgDate DATE,MsgTime TIME,MsgPriority VARCHAR(30),MsgHostname VARCHAR(255),MsgText TEXT) SQL
http://www.kiwisyslog.com/help/syslogd7/setup_db_formats.htm - 9.6kb
6. Custom DB formats the commands. Example of SQL commands: Database type: MySQL database Database name: New Format SQL command to create the table: CREATE TABLE Syslogd (MsgDate DATE,MsgTime TIME,MsgPriority VARCHAR(30),MsgHostname VARCHAR(255),MsgText TEXT) SQL
http://www.kiwisyslog.com/help/syslog/setup_db_formats.htm - 10.3kb
7. INFO: Minimum operating system requirements for Kiwi Syslog Server - Kiwi Enterprises SQL Server Compact 3.5 SP1 http://download.microsoft.com/download/8/4/2/8423C019-CCB4-4D7D-B7F0-BCF83F1B9218/SSCERuntime-ENU-x86.msi Kiwi Syslog Web Access (x64) Windows Installer 3.1 Visual C++ 2008 SP1
http://www.kiwisyslog.com/index.php?option=com_kb&page=articles&articleid=80&Itemid=244 - 80.7kb
8. The script functions database using DSN, Table, SQLcmd and Timeout of 30 seconds .VarCustom01 = .ActionLogToODBC(MyDSN, MyTable, SQLcmd, 30) ' VarCustom01 now holds the return value from the function. End with Function Quote(Data) ' Replace all occurrences of ' with
http://www.kiwisyslog.com/help/syslog/the_script_functions.htm - 39.7kb
9. The script functions database using DSN, Table, SQLcmd and Timeout of 30 seconds .VarCustom01 = .ActionLogToODBC(MyDSN, MyTable, SQLcmd, 30) ' VarCustom01 now holds the return value from the function. End with Function Quote(Data) ' Replace all occurrences of ' with
http://www.kiwisyslog.com/help/syslogd7/the_script_functions.htm - 21.5kb
10. HOW TO: Create a Custom DB format - Kiwi Enterprises if you press the ' Show SQL commands ', the date should be how you want to see it. 5. Give your new format a name i.e x format 6. Amend your ' Log to ODBC ' Action by selecting the new custom DB format name from the ' Database
http://www.kiwisyslog.com/index.php?option=com_kb&page=articles&articleid=83&Itemid=244 - 32.2kb
|