June 6, 2014 at 7:49 pm
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
June 7, 2014 at 3:59 pm
Hi
Did you try to find out the value for which the conversion is failing?
Igor Micev,My blog: www.igormicev.com
June 8, 2014 at 7:40 pm
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.
June 8, 2014 at 10:26 pm
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.
😎
June 9, 2014 at 3:07 am
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 ?
June 9, 2014 at 3:23 am
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