Re: SQR 5528

[Sylvain Leclair <sleclair@HOTMAIL.COM>]

Duncan,


Do you know if same error will happen with a SQL server database? For now, I
make the report with sqlbase. I was using the Centura SqlBase driver and
after your suggestion, I try using the SQR ODBC driver for SqlBase, but it's
still not working. I also ask my boss when the version 5 will be
release...in 2 years!


>From: "C. Duncan Hudson" <c_duncan_hudson@YAHOO.COM>
>Reply-To: SQR-USERS@list.iex.net
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>Subject: Re: SQR 5528
>Date: Thu, 29 Jul 1999 10:12:48 -0700
>
>Sylvain Leclair wrote:
>
> > I hope I'm at the right place to ask my question.
> > I'm trying to make a SQR report which use a lot of
> > procedure, table and select. But I get this error
> > from one of my procedure :
> >
> > (SQR 5528) ODBC SQL dbexec: SQLExecute error 0 in
> > cursor 6:
> > [INTERSOLV][ODBC SQLBase driver]Data type for
> > parameter 1 has changed since first SQLExecute call.
> >
> > Error on line 329:
> > (SQR 3723) Problem executing cursor.
>
>Sylvain,
>
>I struggled with this error for a very long time
>before I got PSDI (my SQR vendor) to acknowledge that
>the problem had nothing to do with my code.  The
>problem is, in fact, due to the buggy Intersolv ODBC
>driver.  My environment was Oracle, so I was able to
>fix the problem by switching to the Oracle ODBC
>drivers.  I was also using SQR 4.01 at the time, PSDI
>informed me that the bug would be fixed in version 5
>of the package.  I don't know if that has shipped yet
>or not.  Hope this helps,
>
>
>Dunc.
>
>_____________________________________________________________
>Do You Yahoo!?
>Free instant messaging and more at http://messenger.yahoo.com


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com