Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need Help about error converting data type Expand / Collapse
Author
Message
Posted Friday, June 6, 2014 7:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 7:20 PM
Points: 3, Visits: 8
hi...i have a VB6.0 based application in my PC, this application stored a few data to MSDE (SQL Server 2000) and running well in Windows Xp..

You know all that microsoft has stop their support for Windows XP, therefore i want to upgrade my PC to Windows 7..But unfortunately when i done with OS upgrade, my VB based application doesn't work, it says "Error converting data type VarChar to Numeric" when i send a data to MSDE.. i already try to upgrade MSDE to SQL Express 2005 and SQL Express 2008 but it still can't work.

I also Try using SQL Express 2005 and SQL Express 2008 in windows XP and running my VB based application...it work fine..

Is this somekind of windows 7 bug or SQL Express bug?

Need help...pLease....

PS : I dont change any of my database field's data type

Sorry...bad english
Post #1578556
Posted Saturday, June 7, 2014 3:59 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 8:54 AM
Points: 3,084, Visits: 3,196
Hi
Did you try to find out the value for which the conversion is failing?




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1578611
Posted Sunday, June 8, 2014 7:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 7:20 PM
Points: 3, Visits: 8
Hi...Thanks for the reply...yesterday i try to accsess the target database to find out all of the field's data type and i didn't find anything wrong, except when i send "0" the error doesn't occur, but when i send other number except "0" then the error occur..FYI. i didn't send alphanumeric just numeric so i presume that there is no data type convertion because the target database field is also numeric.
Post #1578690
Posted Sunday, June 8, 2014 10:26 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:07 AM
Points: 2,420, Visits: 6,729
Quick thought, is it an option to upgrade the VB6 application? VB 2008 has a conversion option, think that's the last version where it's included.

The problem sounds like the application is relying on an implicit type cast.
Post #1578698
Posted Monday, June 9, 2014 3:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 7:20 PM
Points: 3, Visits: 8
Thanks for the reply, i will try to upgrade the application to VB2008, if i can find the source code , because it's not my program..

anyway could vb2008 conver the exe file created with vb6 ?
Post #1578734
Posted Monday, June 9, 2014 3:23 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:07 AM
Points: 2,420, Visits: 6,729
abuhaidar82 (6/9/2014)
Thanks for the reply, i will try to upgrade the application to VB2008, if i can find the source code , because it's not my program..

anyway could vb2008 conver the exe file created with vb6 ?


No, you need the source code.
Post #1578739
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse