Help on chain view 3.10.

Post Reply
User avatar
rumbler75
Nouveau
Nouveau
Posts: 22
Joined: 16 Oct 2006 12:00
Location: Helsinki

Help on chain view 3.10.

Post by rumbler75 » 22 Nov 2007 3:22

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

User avatar
fyot
Nouveau
Nouveau
Posts: 736
Joined: 26 Apr 2005 12:00
Location: PARIS
Contact:

Post by fyot » 22 Nov 2007 4:07

Hi

Are you defined your DNS named CONTROLM under ODBC ?
You must defined it before.

User avatar
rumbler75
Nouveau
Nouveau
Posts: 22
Joined: 16 Oct 2006 12:00
Location: Helsinki

Post by rumbler75 » 23 Nov 2007 8:11

Yes I did tried through Start --> Control Panel --> Administrative Tools --> Data Sources (ODBC), but not with good success. If my EM uses Sybase dedicated db, do I need a driver from sybase, because I couldn't find it in the selection list or can I use a text file? Thanks fyot.

User avatar
philmalmaison
Nouveau
Nouveau
Posts: 1148
Joined: 08 Jun 2007 12:00
Location: Ile de France

Post by philmalmaison » 23 Nov 2007 9:36

probably have to install sybase client to setup all parameters
regards
Philmalmaison

User avatar
fyot
Nouveau
Nouveau
Posts: 736
Joined: 26 Apr 2005 12:00
Location: PARIS
Contact:

Post by fyot » 23 Nov 2007 10:12

Hi

Of course you need to have to install Sybase client at first,
and principally ODBC driver for Sybase.

User avatar
rumbler75
Nouveau
Nouveau
Posts: 22
Joined: 16 Oct 2006 12:00
Location: Helsinki

Post by rumbler75 » 23 Nov 2007 11:04

Dummy head continues, If I have installed the EM client, there must be a sybase client installed as well or am I totally out?

User avatar
fyot
Nouveau
Nouveau
Posts: 736
Joined: 26 Apr 2005 12:00
Location: PARIS
Contact:

Post by fyot » 23 Nov 2007 2:30

It's true You have installed Sybase client but I'm not sure ODBC client is installed in the same way.

User avatar
rumbler75
Nouveau
Nouveau
Posts: 22
Joined: 16 Oct 2006 12:00
Location: Helsinki

Post by rumbler75 » 29 Nov 2007 2:36

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

User avatar
fyot
Nouveau
Nouveau
Posts: 736
Joined: 26 Apr 2005 12:00
Location: PARIS
Contact:

Post by fyot » 29 Nov 2007 8: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.

Post Reply