Dirk, Sorry, I was on the road this morning so my email was brief and in accurate.
I understand what you mean. I am looking at the window. You don't create a table with a specific name. You pull that from the configuration window. I see that now. I'm going to go back and review my network admin. He is in the process of moving us from 5.whatever to 6.1 and he must have entered the table name wrong. I distinctly remembered the [CreateTable] button on that dialog box and through that SA created a table with a set name. We have a lot of problem with other vendors not writing code that is SQL case-sensitive so I made an assumption that was the problem here. Turns out your code was perfect and it was pilot error. Actually, we call that a PICNIC problem: Problem In Chair, Not In Computer. Sorry for the confusion. -Tom -----Original Message----- From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Dirk Sent: Wednesday, October 08, 2008 9:46 AM To: Servers Alive Discussion List Subject: RE: [SA-list] Bug: Logging to Database Same as for the db names, we use them as you enter them within the interface of SA. Could it be that you changed one of them? What db logging are you looking at? Dirk Bulinckx. -----Original Message----- From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Vogl, Tom Sent: Wednesday, October 08, 2008 3:35 PM To: Servers Alive Discussion List Subject: RE: [SA-list] Bug: Logging to Database Sorry, not database names, Table names. the table names in your "create" script are not case identical to names in your "Insert" statements. -----Original Message----- From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Dirk Sent: Friday, October 03, 2008 5:45 PM To: Servers Alive Discussion List Subject: RE: [SA-list] Bug: Logging to Database the database names are the ones that you enter within Servers Alive. We don't change the case of it. Dirk Bulinckx. -----Original Message----- From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Vogl, Tom Sent: Friday, October 03, 2008 11:15 PM To: Servers Alive Discussion List Subject: [SA-list] Bug: Logging to Database Dirk, We found a minor bug in the Log to Database area. We use a case-sensitive SQL instance (don't ask). The "Create Tables" button in SA 6.1 creates a table called "sadataprod", but the INSERT statement within your code trys to write to a table called "SAdataprod". In our world, they ain't the same. Same thing applies to the other log tables, create names <> insert table names Our fix was to rename the tables in SQL so I would suggest you just modify the create scripts. -Tom To unsubscribe send a message with UNSUBSCRIBE in the subject line to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list.= To unsubscribe send a message with UNSUBSCRIBE in the subject line to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list. To unsubscribe send a message with UNSUBSCRIBE in the subject line to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list.= To unsubscribe send a message with UNSUBSCRIBE in the subject line to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list. To unsubscribe send a message with UNSUBSCRIBE in the subject line to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list.
