The 'vfpoledb.1' provider is not registered on the local machine.

Not able to find the solution for this error message "The 'vfpoledb.1' provider is not registered on the local machine."?

Here is the solution:

1. Download the msi file from here, https://www.microsoft.com/en-us/download/details.aspx?id=14839, and make sure you install as Everyone. If you choose Only Me, you will hit the same error message.
2. Build your application, regardless it is a web application or desktop application, in x86 mode.

Happy coding!

Want to know your MySQL database size?

Well, you can try the script below:

Select
table_schema As "Database Name",
Round(Sum(data_length + index_length) / 1024 / 1024, 2) As "Database Size in MB"
From information_schema.Tables
Where table_schema = 'xxxxx'
Group By table_schema
Order By table_schema;

It takes years to output data via Microsoft SQL Server BCP (Bulk Copy Program utility)?

If you are using Microsoft SQL Server BCP (Bulk Copy Program) utility, or a.k.a. XPShellCmd, and you found that your scripts take forever to execute.

Solution:

a). Always make sure your Select statement comes with NoLock for each tables.

It takes years to sign in Skype for Business?

This issue in fact bugs me for months, and it only happens on my personal laptop (a Windows 10). It won't go away even I have cleared the cache for Skype for Business, delete the sign in information, etc.

Until I checked the tracing log file, and it mentioned that there is a loop while accessing my Wi-Fi adapter, I start to narrow down the possible root cause: Network adapter.

And finally I managed to get it fixed, by turning off Internet Protocol Version 6 (IPv6).

Repository has not been enabled to accept revision propchanges; ask the administrator to create a pre-revprop-change hook

Not able to edit log message in your SVN?

Solution:

a). Go to your repository\hooks folder.

b). Create a file called "pre-revprop-change.bat".

c). Put the following contents into that file, and then save it.

rem Only allow log messages to be changed.
if “%4” == “svn:log” exit 0
echo Property ‘%4’ cannot be changed >&2
exit 1

d). Now, edit the SVN log message again. You should be able to edit the message now.

Yahoo shows off password...

Yahoo shows off password free logins and new encrypted email technology

Original post is at here.

Unable to CTRL + SHIFT + F in Visual Studio?

In order to resolve this issue, you may go to Visual Studio > Window > Reset Window Layout.