ODBC Run ime error’- 2147217900 (80040e14)

Asked By 0 points N/A Posted on -
qa-featured

Hello,

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?

Thank you

Samuel

Moscow 19-12-07

Run-time error’-2147217900 (80040e14)’:

[MySQL][ODBC 3.51 Driver][mysqld-5.0.24a-community-nt-log]Duplicate entry ‘45331’ for key 1

SHARE
Answered By 0 points N/A #123302

ODBC Run ime error’- 2147217900 (80040e14)

qa-featured

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.

-Thompson Locker

 

Login/Register to Answer

Related Questions