1. Martin Johannes Vlok
  2. PowerBuilder
  3. Tuesday, 13 September 2022 14:19 PM UTC

We developed a program with PowerBuilder 12.5 running on Sybase SqlAnywhere 9. We had a module KCrystal calling a Crystal Report from the software without any problems.

We have now moved to MS SQL Server 2017 and the software runs normally except the callout for the Crystal Report is not functioning anymore. We receive "Invalid Type Parameters".

Is there anything we have to change or do for the KCrystal.jar to work in SQL Server. We also changed our jdbc in the database to sqlserver instead of sybase.

Anybody experienced the same or can provide assistance please.

Martin Vlok
martin.vlok@optilog.co.za

Olan Knight Accepted Answer Pending Moderation
  1. Tuesday, 13 September 2022 17:00 PM UTC
  2. PowerBuilder
  3. # 1

Martin -

   Often, different databases have slightly different definitions of their datatypes.

   Look at the call to Crystal Reports and examine the datatypes of the parameters. Then look at your database and ensure that the datatypes actually exist in the databases. You may need to re-TYPE one or more of the parameters. Example:  A call parameter is VARCHAR2(20), but your database does not support the VARCHAR2() datatype and uses CHAR() instead. (That's just an example, it's not meant to reflect reality!)

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.