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.

Increase bScale in DBPARAMBINDINFO or column scale

2 posts in General Discussion Last posting was on 2012-09-04 14:09:49Z
Jim Klocksin Posted on 2012-06-06 11:46:42Z
Sender: 4a94.4fcf4195.1804289383@sybase.com
From: Jim Klocksin
Newsgroups: sybase.public.powerbuilder.general
Subject: Increase bScale in DBPARAMBINDINFO or column scale
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fcf4322.4ad5.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 6 Jun 2012 04:46:42 -0700
X-Trace: forums-1-dub 1338983202 172.20.134.41 (6 Jun 2012 04:46:42 -0700)
X-Original-Trace: 6 Jun 2012 04:46:42 -0700, 172.20.134.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:246494
Article PK: 693947

Using the SQL Server Native Driver SQLNCLI10 datatime fields
return the following error message:

SQL ERROR, return code = -1...
DBMS Vendor Return Code = 999...
DBMS Vendor Message Text: SQLSTATE = 22007
Microsoft SQL Server Native Client 10.0
The fractional part of the provided time value overflows the
scale of the corresponding SQL Server parameter or column.
Increase bScale in DBPARAMBINDINFO or column scale to
correct this error.

This does NOT occur with the prior version (SQLNCLI) of the
SQL Server Native Driver. I'm assuming that I'm not the
only person who's run across this problem....Can anyone
provide me with the solution to this?

TIA,
Jim Klocksin


Arnd Schmidt Posted on 2012-09-04 14:09:49Z
Reply-To: "Arnd Schmidt" <arnd.schmidt@no-spam-at-work.org>
From: "Arnd Schmidt" <arnd.schmidt@no-spam-at-work.org>
Newsgroups: sybase.public.powerbuilder.general
References: <4fcf4322.4ad5.1681692777@sybase.com>
Subject: Re: Increase bScale in DBPARAMBINDINFO or column scale
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50460bad@forums-1-dub>
Date: 4 Sep 2012 07:09:49 -0700
X-Trace: forums-1-dub 1346767789 172.20.134.152 (4 Sep 2012 07:09:49 -0700)
X-Original-Trace: 4 Sep 2012 07:09:49 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:247717
Article PK: 695455

Ran into this today using PowerBuilder 10.5.

Adding "DataTypeCompatibility=80" to the Providerstring helped.


<Jim Klocksin> schrieb im Newsbeitrag news:4fcf4322.4ad5.1681692777@sybase.com...

> Using the SQL Server Native Driver SQLNCLI10 datatime fields
> return the following error message:
>
> SQL ERROR, return code = -1...
> DBMS Vendor Return Code = 999...
> DBMS Vendor Message Text: SQLSTATE = 22007
> Microsoft SQL Server Native Client 10.0
> The fractional part of the provided time value overflows the
> scale of the corresponding SQL Server parameter or column.
> Increase bScale in DBPARAMBINDINFO or column scale to
> correct this error.
>
> This does NOT occur with the prior version (SQLNCLI) of the
> SQL Server Native Driver. I'm assuming that I'm not the
> only person who's run across this problem....Can anyone
> provide me with the solution to this?
>
> TIA,
> Jim Klocksin