I recreated the table when updating to 4.0.1330, with the older version was not able
to even create the table but now I'm able to do that with version 4.0.1330.
Regards Johan
-----Oprindelig meddelelse-----
Fra: [EMAIL PROTECTED] på vegne af Dirk Bulinckx
Sendt: on 12-03-2003 19:46
Til: [EMAIL PROTECTED]
Cc:
Emne: RE: [SA-list] Database logging with oracle
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
<<winmail.dat>>
