Error in IDT 4.1

[Former Member]

Hello All,

  I am working on a universe in 3.1 with derived table (with prompts) with SQL Server as the backend database.I migrated this universe to 4.1,converted it to .unx format and tried testing the connection but got the error in the attachment.Also,migrated the 3.1 report pointing to this universe to 4.1 and tried running it against .unv format of the this universe and had no issues.But when tried running against the .unx, got a similar message.

Please advise.

Thanks !!!!

[Former Member]

What type of connection are you using in IDT? CLSID relates to a Native Client error, where I think you need to install the SQL Server Native Client software on the Webi server and any computers that are using IDT.