Author Topic: Sybase native driver problem with cognos reports  (Read 6519 times)

Offline yousuf_248

  • Full Member
  • ***
  • Join Date: Jun 2009
  • Posts: 10
  • Forum Citizenship: +0/-0
Sybase native driver problem with cognos reports
« on: 16 Jul 2009 10:31:35 am »
Hi All,

I have found some strange thing. I am developing reports using cognos 8.2. Db used is Sybase 15.0.3. I created a data source using Sybase CT Lib and tried to create a report.
Here comes the problem...i tried pulling a field whose type is "CHAR" and size defined for that is 100. I have roughly 4000 records in DB, but my report is pulling only 1200 records. If i pull any other field(size of which is less than or around 50) i get all records. Is there any size limit for Sybase CT Lib to fetch data from DB?

I tried work around and created another data source with type as "ODBC" and tried running the report. It fetched all the records.
I have three restrictions from customer

1)Data source using ODBC cannot be used
2)DB admin is not ready to limit the size of field.
3)Display of that field in the report is a must.

Can anyone suggest us work around to get all the records using native driver and without limiting the size of column in DB?

Thanks in advance.

Offline DustPanMan

  • Community Leader
  • *****
  • Join Date: Aug 2005
  • Posts: 138
  • Forum Citizenship: +8/-0
    • COGNOiSe.com
Re: Sybase native driver problem with cognos reports
« Reply #1 on: 22 Jul 2009 11:29:24 am »
Yousuf,

This is happening because blank rows are ignored.  If you pull a key column with this one, you will likely get all of your records.

Best regards,

Dustin
Best,

D

Offline napster_gr8

  • Full Member
  • ***
  • Join Date: Apr 2013
  • Posts: 11
  • Forum Citizenship: +0/-0
Re: Sybase native driver problem with cognos reports
« Reply #2 on: 26 Aug 2015 05:24:10 am »
hi yousuf,

We are struggling to connect sybase 12.5 with cognos 10.2.2.
We are unable to create a data source using the CT-lib.

Could you mention the steps or guide me to the resource of successfully creating the data source.
We understand its been 6 years since you came across it.

We have a similar restriction
Data source using ODBC cannot be used

Anyone else facing a similar problem and can suggest a solution?

Thanks in advance
-
Naps

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,202
  • Forum Citizenship: +662/-10
  • Cognos Software Muppet
Re: Sybase native driver problem with cognos reports
« Reply #3 on: 26 Aug 2015 05:48:04 am »
hi yousuf,

We are struggling to connect sybase 12.5 with cognos 10.2.2.
We are unable to create a data source using the CT-lib.

Could you mention the steps or guide me to the resource of successfully creating the data source.
We understand its been 6 years since you came across it.

We have a similar restriction
Data source using ODBC cannot be used

Anyone else facing a similar problem and can suggest a solution?

Thanks in advance
-
Naps

Hi,

This is a very old post in the Cognos 8 section of the forum. I'd suggest you create a new post in the Administration section of the Cognos 10 area.

MF.
Meep!