COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: krishna1684 on 03 Feb 2011 02:47:04 AM

Title: Data Manager Connection Error
Post by: krishna1684 on 03 Feb 2011 02:47:04 AM
Hi,

i have created a dsn. I am able to test the dsn successfully from command prompt. but when i am connecting it from datamanager i am facing the following problem.

1. ERROR
DM-DBM-0402 UDA driver reported the following:

UDA-SQL-0031 Unable to access the "ALIAS_04876F08" database.

UDA-SQL-0107 A general exception has occurred during the operation "attach".
--------------------------------------------------------------------------------
2. ERROR
DM-DBM-0306 UDA driver error connecting to 'ALIAS_04876F0

I am trying this for the past 2 das but couldnt resolve. please let me know how to solve this error. thanks in advance
Title: Data Manager Connection Error
Post by: MFGF on 03 Feb 2011 05:03:11 AM
Hi,

What kind of database are you connecting to? Are you using the native client drivers to connect, or ODBC? Is the database client (or ODBC connection) set up on the machine running your Data Manager Designer?

MF.


Snet form my fumblefingers
iPhon 5 usig Tapatalk
Title: Re: Data Manager Connection Error
Post by: krishna1684 on 03 Feb 2011 05:49:50 AM
Hi,

I am connecting to an ERP through ODBC. The odbc connection is tested independently and is connecting to the  ERP server from the cognos connection. however it is failing if trying to connect from DM.
Title: Re: Data Manager Connection Error
Post by: MFGF on 03 Feb 2011 06:07:57 AM
Hi,

Cognos Connection is the C8 web portal, so any connectivity you see there is between your Cognos 8 server and the database. Data Manager Designer is a client application, so if you are using it on your local machine rather than the C8 server, you will need the relevant ODBC connection setting up on your local machine.

Regards,

MF.
Title: Re: Data Manager Connection Error
Post by: krishna1684 on 03 Feb 2011 10:32:02 PM
Hi,
It was working fine earlier with same above mentioned configuration. But now when i am trying to connect it is failing.
Title: Data Manager Connection Error
Post by: MFGF on 04 Feb 2011 04:47:49 AM
Have you checked that the ODBC dsn is still defined and working correctly on your local machine?


Snet form my fumblefingers
iPhon 5 usig Tapatalk