2X - Runtim Error: Data-conversion error resulted in overflow

I am running PB6.5.1 using Microsoft SQL Server  7.00 - 7.00.842, Standard
Edition on Windows NT 4.0 (Build 1381: Service Pack 4) and receiving the
following error at run time: "Data-conversion error resulted in overflow."

The application datawindow works fine in the IDE, but dies a  most glorious
death once compiled.  The dw column is tied to a dddw, the data column in
the dddw is defined as  an 'int' in the database; as a long (or as a
number - I have tried both) in the dw and the dddw.  The application
previously was connected to Sybase database, but since the conversion to
MSSQL 7, I keep running into this error.

Any ideas?????

Thanks.

Rex




0
MacGregor
1/5/2001 5:39:03 PM
sybase.powerbuilder.datawindow 28057 articles. 4 followers. Follow

0 Replies
1594 Views

Similar Articles

[PageSpeed] 46

Reply:

Similar Artilces:

Data conversion error result in overflow
Hi: I have the following problem and need some help: I am using PB6.5 and MSSQL7.0 in Win NT 4.0 environment. I have a 18 character long login for MSSQl7.0. When I login from my PB app and execute a store procedure, I got an error saying (DATA CONVERSION ERROR RESULT IN OVERFLOW). I have try to use a select statement from my front end, it still doesn't work. So if any of u have an answer for it, please let me know. Thanks Jason ---== Posted via the PFCGuide Web Newsreader ==--- http://www.pfcguide.com/_newsgroups/group_list.asp 1.1st of all tell me are u assigning ret...

Data-Conversion Error Resulted IN Overflow???
I am running PB6.5.1 using Microsoft SQL Server 7.00 - 7.00.842, Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 4) and receiving the following error at run time: "Data-conversion error resulted in overflow." The application datawindow works fine in the IDE, but dies a most glorious death once compiled. The dw column is tied to a dddw, the data column in the dddw is defined as an 'int' in the database; as a long (or as a number - I have tried both) in the dw and the dddw. The application previously was connected to Sybase database, but since the con...

Select error: Data-conversion resulted in overflow
Hi, We have migrated an app from PB4 to PB6.5 In both cases the database is MS SQL Server 6.5 sp5, native connection. In PB4 all is OK, but with PB6.5.1 we get the above error. Has anyone any clues? Thanks. Herman Mol Check that the selected data matches the receiving var on type and size. For example are you selecting a long into an integer? Herman Mol wrote: > Hi, > > We have migrated an app from PB4 to PB6.5 > In both cases the database is MS SQL Server 6.5 sp5, native connection. > > In PB4 all is OK, but with PB6.5.1 we get the above err...

Select error:Data-conversion resulted in overflow
Hi, PowerBuilder 5.0.02 NT 4.0 MS SQL Server 6.5 First time i opened a table(pubs.dbo.titles) with "grid" mode in database painter , a message box reads: "Select error:Data-conversion resulted in overflow". When i exited database painter and used grid again, the data was retrieved correctly . Then if i didn't exit PB5, database painter always worked well. Just like that database painter had learned something. Thanks for any help!!! In article <01bd549e$a902c960$14ef76ca@oasis>, wyq@rainy.hit.edu.cn says... > Select error:Data-conv...

Select error: Data-conversion resulted in overflow
Hi, We have migrated an app from PB4 to PB6.5 In both cases the database is MS SQL Server 6.5 sp5, native connection. In PB4 all is OK, but with PB6.5.1 we get the above error. Has anyone any clues? Thanks. Herman Mol Check that the selected data matches the receiving var on type and size. For example are you selecting a long into an integer? Herman Mol wrote: > Hi, > > We have migrated an app from PB4 to PB6.5 > In both cases the database is MS SQL Server 6.5 sp5, native connection. > > In PB4 all is OK, but with PB6.5.1 we get the above err...

error error error
These are the 2 new errors i am getting now:   1).  Server Error in '/' Application. Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.Source Error: Line 53: ...

errors errors errors..
Name: harun Email: harunbjk1903hrnatgmaildotcom Product: Firefox Summary: errors errors errors.. Comments: first of all when i launch firefox (3) i cant enter websites via writing.. for example when I type "google" and then press ctrl and enter, it crashes.. and i take lots of error reports. firefox 2 was better.. see you again , harun Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; tr; rv:1.9) Gecko/2008052906 Firefox/3.0 From URL: http://hendrix.mozilla.org/ ...

Error, Error and more errors
Okay, all I wanted to do was test this app out and it has been a nightmare. 1.) Didn't install the sql database. I had to manually install it. 2.) I get errors when trying to add a picture to an album. "Procedure or function ngUpdatePicture has too many arguments specified" Any ideas? I've gotten more errors than this, but there is no use in bitchin. Are you using the v1.6.1 installer? Also, did you select to install the SQL Server db and give it a valid admin login? What were some of the error messages? Did you have an existing DB from a previous install? ...

Error message
We' ve got an application written in PB4.0.3 which we are trying to migrate to PB6.5. In the PB 4 version on start up there is a treeview which displays a list of report groups. Each report group can be expanded/collapsed to specify a report type. There are 3 levels. In the migrated version, on start up only the first level is expandable. When we try to expand the second level - the error message displays...Error message - 'Data conversion has resulted in an overflow.' We have tried the following: Setting the text value in the database profile to 32, 000 as one of t...

DB-Library Error:20049 Data-conversion resulted in overflow
We are getting the following error while execution a stored procedure from PB7.0 Build 7023 within Sybase 11.0.3: DB-Library Error:20049 Severity:4 Message:Data-conversion resulted in overflow. This problem seems to stem from invalid data or a data-length problem. But, my question is, does anyone know if and why such an error can cause the application to hang. It never seems to return an invalid SQL Code, even thought we are checking for one. I'm not sure how to begin resolving this one. Thanks in advance, Craig Rix Does it hang in the DW painter preview? or just wh...

db-lib error 20049 Data-conversion resulted in overflow
We are getting the following error while execution a stored procedure from PB7.0 Build 7023 within Sybase 11.0.3: DB-Library Erro:20049 Severity:4 Message:Data-conversion resulted in overflow. This problem seems to stem from invalid data or a data-length problem. But, my question is, does anyone know if and why such an error can cause the application to hang. It never seems to return an invalid SQL Code, even thought we are checking for one. I'm not sure how to begin resolving this one. Thanks in advance, Craig Rix ...

DB-Library Error:20049 Data-conversion resulted in overflow.
We are getting the following error while execution a stored procedure from PB7.0 Build 7023 within Sybase 11.0.3: DB-Library Error:20049 Severity:4 Message:Data-conversion resulted in overflow. This problem seems to stem from invalid data or a data-length problem. But, my question is, does anyone know if and why such an error can cause the application to hang. It never seems to return an invalid SQL Code, even thought we are checking for one. I'm not sure how to begin resolving this one. Thanks in advance, Craig Rix Craig Rix wrote: > > We are getting ...

ERROR:"Data-conversion resulted in overflow. 1 excute dbo.test;1" in creating DW used StoreProdure
Can you help me! I create a DW used StoreProdure ,(Pb7.01) it's always dislay the error info: "Data-conversion resulted in overflow. 1 excute dbo.test;1" if I take the 'manuel result set' option cheched then has no error. but it's very slowly by this way . please tell me : How to do without 'manuel result set' !!!! Thaks! Moore First of all, I would recommend upgrading to 7.0.2 C3 (build 8046). So, what database? On Mon, 30 Oct 2000 17:33:08 +0800, in powersoft.public.powerbuilder.datawindow moore <brmoonc@263.net> wrote: ...

Error in datawindow error
Hi PowerGuys, I have created datawindow in pb7 and I saved it. In PS file-new-blank html page. I created a blanke html page. Insert activeX control - design tab-sybase html datawindow dtc - selected pbl and datawindow which I want to display on the page. I set generate absolute path-set connect property - enable jaguar component - html generator. saved the page - it automatically deployed to my personal webserver. But, when I browse throug IE5.0 I got an error Line 1 Column 97: incorrect syntax. Where did I go wrong ?. Any one got this error ?. Please help me. Th...

Error error error, help me
Hello, How do I populate a drop down list in asp.net from a database? I have a block of vbscript code that does the server side coding for it. My code is as follows.. <script language="vb" runat="server"> Dim objConn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\data\employee.mdb;") Dim Sql, valEmp As String Dim objDREmp as OleDbDataReader Sub FillEmployeeName(sender As Object, e As System.EventArgs) Sql = "select * from [Employee]" Dim objCommand As Ole...

Web resources about - 2X - Runtim Error: Data-conversion error resulted in overflow - sybase.powerbuilder.datawindow

Data conversion - Wikipedia, the free encyclopedia
Data conversion is the conversion of computer data from one format to another. Throughout a computer environment, data is encoded in a variety ...

Jumpshot Elite Launches To Provide Competitive Search Query And Conversion Data
Marketers can pull up data on other websites to see historic or recent search query and conversion activity based on click activity culled from ...

Google AdWords Missing Content Network Conversions Data
... come from WebmasterWorld that AdWords, since updating the user interface , has some bugs. Specifically, the content network conversion data ...

Portable DVD Writer & Hard Disk Combo is a powerful data conversion station
The cool thing about this new DVD Writer & Hard Disk Combo is the fact that you can now convert your data onto multiple formats all on the same ...

4 Ways to Leverage Your PPC Data Beyond the Point of Conversion
... aside, there is more to PPC than meets the eye . So how can you leverage the gold mine of data you are collecting beyond the point of conversion? ...

Data-Backed Proof For Why Product Video Drives High Ecommerce Conversions
Are you using video on your ecommerce site? If not, you may be missing out. Research shows that customers make significantly more purchases from ...

Your Favorite Automatic Data Endianness Conversion
Your Favorite Automatic Data Endianness Conversion

Linking digital audience data to drive conversions
... and link different channels and manage audiences? Here are four examples where this is working well: 1. Facebook Exchange and web site data ...

The Newsonomics of “Little Data,” Data Scientists, and Conversion Specialists
First published at Nieman Journalism Lab OSLO — Arthur Sulzberger surprised some people recently when asked what he would do differently in ...

Using Internal Search Data To Drive Conversions: An Interview With JP Sherman by @brentcsutoras
... How can websites that use internal search benefit more from it? How can you use the data gathered from your internal search to drive more conversions? ...

Resources last updated: 11/26/2015 3:18:29 PM