IDT- ODBC /OLEDB drivers are not visible while creating the connection

[Former Member]

Hi,

• I am trying convert universe from unv format to unx format. When i clicked convert .unv universe am getting the error saying "Specified RDBMS is invalid: MS Sql Server 2008".

• I have created DSN in both 64 & 32 bit drivers and universe, reports are working with unv format. But why am getting this error?
• Then i tried to create ODBC connection from IDT to "SQL Server 2008 R2".

          Am able to see only JDBC drivers under Drivers-->Microsoft-->MS Sql Server 2008

          but there is no option to select ODBC /   OLEDB drivers.

          Is the error because of this? If yes, what should i do?

Please help me

Thanks in advance.

[Former Member]

This error happens when the BI 4 environment has a connection to different version of database than its being used in the universe... Please make sure you have same version of connection in BI 4 environment as used in the UNV file..

Check the note below for details

1579216 - "com.sap.connectivity.cs.core.CSError: Specified RDBMS is invalid : MS SQL Server 2005" wh...

[Former Member]

Thanks.

The version of the DB is same in both BOXI versions. I could say i am using the same connection instead via unv and unx to test the upgrade scenarios.

It seems like an environment issue.