Re: [tedw]AMX connection to RIM Source

I'm having a similar problem, except
with SQL Server.  I can successfully test the connection but when
I try to test the AMX_c05_s005_Pre_Extract step (the first step in the
extract job) it fails with a similar message.  The lines that follow
the message appear to indicate that some of the parameters in the ODBC
call are either in the wrong place or missing; looks like it's missing
the userid and password to connect to the remote data source, although
I believe that I've got it defined everywhere.  Are you seeing something
similar?

#######################

Joe Howell
Shelter Insurance Companies
(573)-214-6534
jhowell@xxxxxxxxxxxxxxxxxxxx

"Colin Mulkerrins" <Colin.Mulkerrins@xxxxxxxxx>
Sent by: owner-tme10@xxxxxxxxxxxxxxxx

01/28/2005 06:19 AM

Please respond to
tme10@xxxxxxxxxxxxxxxx

To	<tme10@xxxxxxxxxxxxxxxx>
cc
Subject	[tme10] [tedw]AMX connection to RIM Source

Hi,
 
I have just installed Data Warehouse
1.2 on W2k and want to collect ITM data.  I have ITM (Ver 5.1.2) datacollection
running and loading TEDW data into an Oracle 8.1.5 database on AIX.
 
I have installed the AMX onto
the TEDW server and have created the ODBC connection to the ITM Database
(I can connect to the database through sqlplus on the TEDW server), but
it will not connect to the Oracle database when testing the AMX process
- it gives the following error message
 
DWC07356E An agents's processing of a command
of type "connectToSource" failed for edition "0" of
step "?".
Specified driver could not be loaded due
to system error 126 (DataWHSE 3.60 32-bit Oracle8).
RC = 7356 RC2 = 8515
 
Has anybody come accross this
before?  
 
I sense a PMR coming on but I
said that I would ask here first in case anybody has a quick fix
 
Thanks

Regards

Colin Mulkerrins
Enterprise Systems Management
An Post

***********************************************************************************
This e-mail and its attachments, is confidential and is intended for the addressee(s) only. If you are not the intended recipient, disclosure, distribution or any action taken in reliance on it is prohibited and may be unlawful. Please note that any information expressed in this message or its attachments is not given or endorsed by An Post unless otherwise indicated by an authorised representative independently of this message. An Post does not accept responsibility for the contents of this message and although it has been scanned for viruses An Post will not accept responsibility for any damage caused as a result of a virus being passed on.
***********************************************************************************

===============================================

This e-mail is intended only for its addressee and may contain information
that is privileged, confidential, or otherwise protected from disclosure. If
you have received this communication in error, please notify us immediately by
e-mail:
postmaster@xxxxxxxxxxxxxxxxxxxx, and delete the original message.

===============================================