Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: bvk.cognoise on 31 May 2011 04:08:26 AM

Title: how to change server name?
Post by: bvk.cognoise on 31 May 2011 04:08:26 AM
Hi,

i have developed few reports using my package.while developing those reports server also in the system(DB).so while creating package i gave my server name as LOCALHOST.
now i changed my server to another machine.here i changed my server name as ABC/sql2000 .i back up that DB and reports and restored it.i am able to view that packages.

now my problem is after creating a report using that package im getting the following error

QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid.

i guess it may occurs because of changing the server name.now how can i change server name to entire package or reports?


thanks
bvk
Title: Re: how to change server name?
Post by: technomorph on 31 May 2011 04:32:41 AM
If I understand correctly, you will  need to have a look at your data source connections in Cognos Connection. Depending on the database you are using, you may be able to change the server there, or otherwise it looks like you will need to look at your ODBC connections in Control Panel on the server.
Title: Re: how to change server name?
Post by: blom0344 on 31 May 2011 05:17:33 AM
Why use ODBC when you can use OLE/DB?
Title: Re: how to change server name?
Post by: bvk.cognoise on 31 May 2011 06:34:59 AM
Hi blom0344,

i used OLE/DB but still its showing the same error :(

thanks
bvk
Title: Re: how to change server name?
Post by: RobsWalker68 on 31 May 2011 06:43:39 AM
Hi,

Have you checked that the relevant ODBC drivers are installed on the new server of if you are using native SQL OLEDB that SQL connectivity has been set up on the server?

Rgds

Rob
Title: Re: how to change server name?
Post by: bvk.cognoise on 31 May 2011 06:46:13 AM
Hi,

thank you all i am able to connect now. :D

thanks
bvk
Text only | Text with Images