Sybase 11 ODBC Driver Compatibility with COGNOS 8.4

[PRIT AMRIT]

Hi,

Could anyone pls confirm if Cognos 8.4 support Sybase 11 ODBC driver, Since i am unable to connect to the DATA BASE through the ODBC.

NOTE: Everything is fine Sybase 12.5 driver.

VERY URGENT

Thanks
P

[MFGF]

According to the support page here, only version 12.6/12.7 ODBC drivers are supported for Sybase.

Having said that, any ODBC that conforms to the ODBC 3.5 (or higher) spec should work in theory.  It's worth checking what version of the ODBC specification the Sybase v11 ODBC driver conforms to.

Regards,

MF.

[PRIT AMRIT]

Hi MF,

In another environment we have Sybase 12.5 Driver and everything is working fine as I mentioned in my last post.

The strange part is, when i create the DATA SOURCE using Sybase ODBC driver v11, it is succeeding. But when i try to import a Table using the same DATA SOURCE i am getting the below error msg:

----------------------------
RQP-DEF-0177 An error occurred while performing operation 'sqlStart' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "start(error code:-27)".
[INTERSOLV[[ODBC SQL Server driver]Optional feature not implemented.
---------------------------

[PRIT AMRIT]

Cognos Support confirmed that it only supports 12.6 and 12.7 currently

Thanks.

[MFGF]

What the IBM guys will support, and what actually works with Cognos 8 are sometimes slightly different things.  As you found, the v12.5 driver seems to work OK, even though it's not officially supported.  A general rule of thumb you can use to predict whether an ODBC will work with C8 is to read up on which version of the ODBC specification the driver conforms to - if it claims to conform to ODBC 3.5 (or higher) spec, it's a fair bet that it will work (even though it may not be supported).  Obviously there is no warranty or guarantee that this is always true, and you probably shouldn't ring up IBM and complain to them that "I have an ODBC 3.5 spec driver that MF says should work and it doesn't, so it must be a problem with Cognos 8 and you must fix it please IBM!" if you find an exception to this guideline. :) (They would probably fall about laughing if you did call them and say this, and reply "Serves you right for believing that muppet!!")

MF.

[PRIT AMRIT]

ha ha ha.... Actually 12.5 v is the Sybase Native driver.....

Anyway, thanks a lot for your valuable inputs.