Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Problem with stored procedure data source.

2 posts in PB Infomaker Report Writer Last posting was on 1999-03-26 19:46:48.0Z
GQG Posted on 1999-03-26 09:21:02.0Z
Newsgroups: sybase.public.infomaker.general
From: "GQG" <gquian@gapd.es>
Subject: Problem with stored procedure data source.
Date: Fri, 26 Mar 1999 10:21:02 +0100
Lines: 25
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_QQwM4k2d#GA.74@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6454
Article PK: 241438

I'm using IM 6.0 with Informix DS 7.23 through ODBC "Informix-CLI 2.5 (32
bit) 2.12.0002 Intersolv".

I can't make reports selecting Stored procedure data source. I can view
stores procedures in my BD, I can select one of them, but when I return to
the Report painter no columns are show.

ODBD Trace says:

EXIT SQLProcedureColumnsW with return code -1 (SQL_ERROR).

It works well if I use INFORMIX-IN7 Direct Driver.

ODBC Driver supports all Core and Level 1 API functions as well as a set of
the Level 2 functions.

Is it a limitation of my ODBC driver? Can be IM ODBC configuration?

Any help will be appreciated.

Please, answers in group or gquian@gapd.es

TIA


Terry Dykstra Posted on 1999-03-26 19:46:48.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Problem with stored procedure data source.
Date: Fri, 26 Mar 1999 12:46:48 -0700
Lines: 35
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_F#F05D8d#GA.218@forums.sybase.com>
References: <348_QQwM4k2d#GA.74@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6449
Article PK: 241433

I would guess it is a limitation of the ODBC driver. Post this question in
the powerbuilder.database newsgroup. There are more Informix developers out
there.

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

GQG wrote in message ...
>I'm using IM 6.0 with Informix DS 7.23 through ODBC "Informix-CLI 2.5 (32
>bit) 2.12.0002 Intersolv".
>
>I can't make reports selecting Stored procedure data source. I can view
>stores procedures in my BD, I can select one of them, but when I return to
>the Report painter no columns are show.
>
>ODBD Trace says:
>
>EXIT SQLProcedureColumnsW with return code -1 (SQL_ERROR).
>
>It works well if I use INFORMIX-IN7 Direct Driver.
>
>ODBC Driver supports all Core and Level 1 API functions as well as a set of
>the Level 2 functions.
>
>Is it a limitation of my ODBC driver? Can be IM ODBC configuration?
>
>Any help will be appreciated.
>
>Please, answers in group or gquian@gapd.es
>
>TIA
>
>