Need Help about error converting data type

  • 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

  • Hi

    Did you try to find out the value for which the conversion is failing?

    Igor Micev,My blog: www.igormicev.com

  • 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.

  • 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.

    😎

  • Thanks for the reply, i will try to upgrade the application to VB2008, if i can find the source code :-D, because it's not my program..

    anyway could vb2008 conver the exe file created with vb6 ?

  • abuhaidar82 (6/9/2014)


    Thanks for the reply, i will try to upgrade the application to VB2008, if i can find the source code :-D, because it's not my program..

    anyway could vb2008 conver the exe file created with vb6 ?

    No, you need the source code.

    😎

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply