Data Manager Connection Error

[krishna1684]

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

[MFGF]

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

[krishna1684]

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.

[MFGF]

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.

[krishna1684]

Hi,
It was working fine earlier with same above mentioned configuration. But now when i am trying to connect it is failing.

[MFGF]

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