Asked By
Samuuel 0 points N/APosted 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
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.
The kitchen is often considered the heart of the home, and it's no wonder why. It's a place where delicious meals are prepared, where family and friends gather, and where memories are made. Therefore,...
Networking plays a significant role in the functioning of organizations, serving as the foundation for effective communication and collaboration among employees regardless of location. To establish and uphold networking infrastructure, companies heavily depend on...
Having an online presence is very important for any business or person nowadays. It helps to establish your brand and connect with customers while also allowing more people to learn about you. However, building...
The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...
Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...
While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...
Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...
A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software.
1....
Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...
