Mitsubishi Electric MELSEC iQ-R-R00CPU, User Manual

Page: 804 / 1028

802
APPX
Appendix 3 Troubleshooting by Symptom
When the CPU module database access function cannot be used
When the data source name cannot be set
Check the following:
When the connection test fails
When the connection test fails at the data source setting, check the following:
When the ODBC server of the CPU module cannot be connected
When the ODBC server of the CPU module cannot be connected from the personal computer, check the following:
When the connection is disconnected
When the connection of the personal computer and the CPU module to the ODBC server is disconnected, check the
following:
Check item Action
Check if use prohibited characters are used in "Data Source Name". Set "Data Source Name" without using prohibited characters.
Check if the number of use prohibited characters in "Data Source Name"
exceeds the range of use. Set "Data Source Name" with the number of characters within the range of
use.
Check item Action
Check if the CPU module supports the CPU module database access
function. Check that the CPU module supports the CPU module database access
function. (
 Page 1008 Added and Enhanced Functions)
Check if the IP address of the CPU module set in "Server" is correct. Set the correct IP address of the CPU module in "Server". (  Page 247
Data Source Name Setup)
Check if 61461 is set in "Port". Set 61461 in "Port". (

Page 247 Data Source Name Setup)
Check if the absolute path of the database of the CPU module set in
"Database" is correct. Set the correct absolute path of the database in "Database". (

Page 247
Data Source Name Setup)
Check item Action
Check if "invalid login/password" is displayed in the error message on the
personal computer. Check that the login name and password that are set in the module parameter
of the engineering tool match those that are input to connect to the server.
(

Page 244 Built-in database access setting)
Check if "cannot open connection to server; open init timeout" is displayed in
the error message on the personal computer. Check that the correct data source is selected to connect to the database of
the CPU module.
Check if "Communication link failure" is displayed in the error message on the
personal computer. The maximum number of concurrently connectable databases (number of
connections) is used (
 Page 233 Database specifications)
End unused applications connected with the database of the CPU module and
connect with the database again.
Check item Action
Check if the built-in database access timer setting in the module parameter of
the engineering tool is too short. Set the longer time for the built-in database access timer setting. (

Page
244 Built-in database access setting)