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.

Can't base report on stored procedure--'Can't create Datawindow'

2 posts in PB Infomaker Report Writer Last posting was on 1999-05-19 18:16:35.0Z
Frank Burleigh Posted on 1999-05-18 23:55:48.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 18 May 1999 18:55:48 -0500
From: Frank Burleigh <burleigh@indiana.edu>
Organization: Indiana University School of Law
X-Mailer: Mozilla 4.51 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Can't base report on stored procedure--'Can't create Datawindow'
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 17
Message-ID: <348_3741FE04.9A74E686@indiana.edu>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6304
Article PK: 241288

I installed IM65 today to give it a try. I made a db config to our
local ASE 11.9.2 engine via Sybase' odbc driver that came with 11.9.2.
I start a new report, tell it to be tabular and to get data from a SP.
It asks which SP and I tell it. The result is an odbc error:

Cannot create DataWindow

Intersolv SQL ODBC driver: Incorrect syntax near '='.

1 execute dbo.sp_si_addressbest_;0 RETURN_VALUE = :RETURN_VALUE'

I can execute the SP fine from SQL Advantage or from Crytal Reports.

Thanks.
--
Frank Burleigh
Indiana University School of Law
Bloomington, IN 47405
burleigh@indiana.edu 812-855-9170


Terry Dykstra Posted on 1999-05-19 18:16:35.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Can't base report on stored procedure--'Can't create Datawindow'
Date: Wed, 19 May 1999 12:16:35 -0600
Lines: 30
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_bKjamMio#GA.225@forums.sybase.com>
References: <348_3741FE04.9A74E686@indiana.edu>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6301
Article PK: 241284

I'm unfortunately unfamiliar with ASE. I would suggest using the native
drivers. When you install IM, you can select the desired ASE drivers using
the Native Driver button.
I'll try to find out why the ODBC driver is having problems.

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

Frank Burleigh wrote in message <3741FE04.9A74E686@indiana.edu>...
>I installed IM65 today to give it a try. I made a db config to our
>local ASE 11.9.2 engine via Sybase' odbc driver that came with 11.9.2.
>I start a new report, tell it to be tabular and to get data from a SP.
>It asks which SP and I tell it. The result is an odbc error:
>
> Cannot create DataWindow
>
> Intersolv SQL ODBC driver: Incorrect syntax near '='.
>
> 1 execute dbo.sp_si_addressbest_;0 RETURN_VALUE = :RETURN_VALUE'
>
>I can execute the SP fine from SQL Advantage or from Crytal Reports.
>
>Thanks.
>--
>Frank Burleigh
>Indiana University School of Law
>Bloomington, IN 47405
>burleigh@indiana.edu 812-855-9170