Hello,
I have installed EasyPHP 1.8 with the Apache Server. I have modified the em_config file:
P|PRODUCTION|CONTROLM|||emuser|dop6201|620
when I try to enter the page: http://localhost/chainview.php
it gave me the error:
Warning: odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\program files\easyphp1-8\www\chainview.php on line 137
No Database !
Where did I go wrong?
Thanks, Vilppu
Help on chain view 3.10.
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France
Thanks, I get this working after long search for Sybase ASE 12.5 ODBC drivers. Can you also clarify what is the function of the cm_config file, especially param 5 and 6. Which user/passwd I should use?
I get also this kind of error, when I try to viewlog function in job level:
Warning: odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\program files\easyphp1-8\www\viewlog.php on line 45
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in c:\program files\easyphp1-8\www\viewlog.php on line 54
Warning: odbc_result_all(): supplied argument is not a valid ODBC result resource in c:\program files\easyphp1-8\www\viewlog.php on line 55
I get also this kind of error, when I try to viewlog function in job level:
Warning: odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\program files\easyphp1-8\www\viewlog.php on line 45
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in c:\program files\easyphp1-8\www\viewlog.php on line 54
Warning: odbc_result_all(): supplied argument is not a valid ODBC result resource in c:\program files\easyphp1-8\www\viewlog.php on line 55
Hi
em_config concerns only Control-EM database parameters.
em_config is used to list jobs from Control-EM with chainview
example :
P|Production|Sybase ASE ODBC Driver|em620|SERVEUREM,8760|emuser|manager|613
cm_config concerns only all Control-M servers database parameters.
cm_config is used to see logs for a job using viewlog
example :
SERVEURCTM efined for the First Gateway
SERVEURCTM|Sybase ASE ODBC Driver|ctm620|SERVEURCTM,7102|ctrlmuser|password|224
In fact you must declare all HOST linked with GATEWAYs defined in your Control-EM.
em_config concerns only Control-EM database parameters.
em_config is used to list jobs from Control-EM with chainview
example :
P|Production|Sybase ASE ODBC Driver|em620|SERVEUREM,8760|emuser|manager|613
cm_config concerns only all Control-M servers database parameters.
cm_config is used to see logs for a job using viewlog
example :
SERVEURCTM efined for the First Gateway
SERVEURCTM|Sybase ASE ODBC Driver|ctm620|SERVEURCTM,7102|ctrlmuser|password|224
In fact you must declare all HOST linked with GATEWAYs defined in your Control-EM.