It is currently 13 Dec 2018 4:40


Post new topic  Reply to topic  [ 9 posts ] 
Author Message
 Post subject: Help on chain view 3.10.
PostPosted: 22 Nov 2007 3:22 
Offline
Nouveau
Nouveau
User avatar

Joined: 16 Oct 2006 12:00
Posts: 22
Location: Helsinki
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: 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


Top
   
 Post subject:
PostPosted: 22 Nov 2007 4:07 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 722
Location: PARIS
Hi

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


Top
   
 Post subject:
PostPosted: 23 Nov 2007 8:11 
Offline
Nouveau
Nouveau
User avatar

Joined: 16 Oct 2006 12:00
Posts: 22
Location: Helsinki
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.


Top
   
 Post subject:
PostPosted: 23 Nov 2007 9:36 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 1148
Location: Ile de France
probably have to install sybase client to setup all parameters
regards
Philmalmaison


Top
   
 Post subject:
PostPosted: 23 Nov 2007 10:12 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 722
Location: PARIS
Hi

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


Top
   
 Post subject:
PostPosted: 23 Nov 2007 11:04 
Offline
Nouveau
Nouveau
User avatar

Joined: 16 Oct 2006 12:00
Posts: 22
Location: Helsinki
Dummy head continues, If I have installed the EM client, there must be a sybase client installed as well or am I totally out?


Top
   
 Post subject:
PostPosted: 23 Nov 2007 2:30 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 722
Location: PARIS
It's true You have installed Sybase client but I'm not sure ODBC client is installed in the same way.


Top
   
 Post subject:
PostPosted: 29 Nov 2007 2:36 
Offline
Nouveau
Nouveau
User avatar

Joined: 16 Oct 2006 12:00
Posts: 22
Location: Helsinki
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


Top
   
 Post subject:
PostPosted: 29 Nov 2007 8:55 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 722
Location: PARIS
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.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 9 posts ] 

All times are UTC+01:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved