ODBC Run ime error’- 2147217900 (80040e14)

Asked By Samuuel 0 points N/A Posted on - 12/19/2011

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

• Status: Open
• Question Views: 1804
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Thompson Locker 10 points N/A #123302

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.

-Thompson Locker

 

About Thompson Locker

Questions
0

Answers
619

Best Answers
77

• Vote Up 0 Vote Down

• Posted on - 01/01/2012
• Question Category: Oracle Database