Did you recreate the table when updating to 4.0.1330? (or change the structure of the table) as indicated on the website?
dirk. -----Original Message----- From: Johan Sandin [mailto:[EMAIL PROTECTED] Behalf Of Johan Sandin Sent: Wed Mar 12 7:41 PM To: [EMAIL PROTECTED] Subject: SV: [SA-list] Database logging with oracle The name of the ODBC entry is salive and nothing more. And the SERVERS_ALIVE_INTERCHANGE is the table within the salvie database. Regards Johan -----Oprindelig meddelelse----- Fra: [EMAIL PROTECTED] på vegne af Dirk Bulinckx Sendt: on 12-03-2003 14:31 Til: [EMAIL PROTECTED] Cc: Emne: RE: [SA-list] Database logging with oracle Could it that "SERVERS_ALIVE_INTERCHANGE" is the name of the ODBC entry or of the table that you're using? dirk. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Johan Sandin Sent: Wed Mar 12 2:28 PM To: [EMAIL PROTECTED] Subject: [SA-list] Database logging with oracle I’ve tried now to log to an oracle database for sometime. The thing is that creating the tables in my salive database works just fine, but when SA tries to write down to the database It fails. I’m running SA Enterprise version 4.0.1330. In my log file it says for the table servers_alive_interchange 12. marts 2003 12:31:04 ERR DB_Update_Interchange_DB : -2147217900([Oracle][ODBC][Ora]ORA-00900: ugyldig SQL-sætning - 0-P) UID:1 time/date: 12-03-200312:31:00. I tried to enable odbc Tracing but can’t really find anything interesting other than : serversalive 1a64-1a60 ENTER SQLExecDirectW HSTMT 03362F28 WCHAR * 0x03244828 [ 25] "SERVERS_ALIVE_INTERCHANGE" SDWORD 25 serversalive 1a64-1a60 EXIT SQLExecDirectW with return code -1 (SQL_ERROR) HSTMT 03362F28 WCHAR * 0x03244828 [ 25] "SERVERS_ALIVE_INTERCHANGE" SDWORD 25 DIAG [37000] [Oracle][ODBC][Ora]ORA-00900: ugyldig SQL-sætning (900) It seem like it is trying to us a function (procedure) called "SERVERS_ALIVE_INTERCHANGE" but it is not a function or procedure it is a table ??? Kind Regards Johan Sandin Sysadmin MCP, MCSA Banestyrelsen IT Pakhusvej 10 DK-2100 Copenhagen Denmark Tel.: +45 8234 0000
<<attachment: winmail.dat>>
