Could not import Additional Datasource

[Sak]

Hello Friends,

I have created an FM with datasource as SQL Server. Now i have to import additional fields from PeopleSoft (Oracle) database.
When i tried to import that through existing FM model, i'm getting an error msg as below. Kindly help me out on how to resolve this. Thanks.

QE-DEF-0285 The logon failed.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
PeopleSoft

UDA-SQL-0031 Unable to access the "PeopleSoft" database.
UDA-SQL-0532 Data Source is not accessible: "HR90ST".
ORA-12154: TNS:could not resolve the connect identifier specified

[cognostechie]

This has nothing to do with bringing additional fields.

Try to run an existing query subject and see if it can show the data in FM. It would probably give you the same error.

Why is it using ODBC if the database is SQL Server? If ODBC is actually needed, check the connection parameters.

[Sak]

Hi,
Thanks for your reply.
One of the data source is SQl Server and another data source is Oracle.
Is that anything do i need to check from DB side?

[Sak]

The issue got resolved.
The TNS name in the Server and in my Local machine where FM is there are different.
Once copied the TNS from server to my local machine, i could able to import.
Thanks.

[Sak]

I have got an another error while i tried to reopen the FM.
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
PeopleSoft

UDA-SQL-0031 Unable to access the "PeopleSoft" database.
UDA-SQL-0107 A general exception has occurred during the operation "attach".

Any ideas to resolve this issue???

[blom0344]

Check whether the acccount you are using has sufficient rights to read from the database you want to access and whether you have defined the proper signon on the cognos connection.
By the way, why are you not using native connectivity?