Тема / Topic: error about ODBC COMMUNIATION WHIT SQL server 7.0
leeman
Junior Member / Новичок
Участник № / Member № 770
отправлено / posted 12-01-2004 11:29
RTM communicates with SQL server 7.0 in a remote PC via ODBC protocol. there is a SQL_Execute type channel in the project with setting C3 > 16. in this case, the RTM will occur some error(displays "application error") after launched 30 seconds later if the communication between the PC where RTM launched and the remote PC where SQL server run failed.
Сообщения / Posts 11 | Из / From: China
| IP / IP: IP адрес / IP address |
отправлено / posted 12-01-2004 14:49
That's right! If the SQL Server wasn't started well the Trace Mode can't reload ODBC configuration and reinstall exchange with it.
Сообщения / Posts 17397 | Из / From: Россия
| IP / IP: IP адрес / IP address |
leeman
Junior Member / Новичок
Участник № / Member № 770
отправлено / posted 13-01-2004 04:46
I don't think it is normal. for a project, the RTM is the main body, it should not be so easy to effected by a 3rd application or some communication method.
Сообщения / Posts 11 | Из / From: China
| IP / IP: IP адрес / IP address |
отправлено / posted 13-01-2004 09:38
So, you mean that RTM can't work well when the message "application error" appear?
Сообщения / Posts 17397 | Из / From: Россия
| IP / IP: IP адрес / IP address |
leeman
Junior Member / Новичок
Участник № / Member № 770
отправлено / posted 13-01-2004 10:26
you can test it, create a SQL_Execute type channel in a project with setting C3 > 16, operating with a SQL server TABLE in a remote PC. if the ethernet failed before RTM launched, RTM will occur some error when you launch it. so the ODBC communicating error will effect the RTM launch! it is unreasonable!
Сообщения / Posts 11 | Из / From: China
| IP / IP: IP адрес / IP address |
отправлено / posted 13-01-2004 11:23
I think the reason is not in the ODBC - it is a DCOM problem. Because it looks like situation with OPC exchange - when it's break the RTM fails after 30 seconds. We will try to make some tests to solve this problem.
Сообщения / Posts 17397 | Из / From: Россия
| IP / IP: IP адрес / IP address |
Printer-friendly view of this topic
