N/APosted on - 12/19/2011
This is the situation that I had yesterday. OS Windows XP, Virtual basic 6, ODBC 3.51. Recently we had some problems with electricity. After that I got error message whenever VB6 via ODBC receives and send data to MySQL. Any suggestions/solution/ advice?
Run-time error’-2147217900 (80040e14)’:
[MySQL][ODBC 3.51 Driver][mysqld-5.0.24a-community-nt-log]Duplicate entry ‘45331’ for key 1
ODBC Run ime error’- 2147217900 (80040e14)
The problem is possibly occurring because there is some bug in the form where you have declared the code, and therefore you will need to go to that form where you got the error, and then you will need to do a Debug.Print of strSql2. That will help you spot the error by studying the Debug.print text that will be generated.
The second workaround that I will recommend for your issue will be to check the data type for "Exchange Rate" that you are using in the database. In case you have got an "Integer" or "Long" data type, you might want to change it to Single or Currency Data Type and see the effect it will bring.