Tag Archives: Database

Solve an issue encountered when SpotFire read Microsoft Access database

Situation: SpotFire read data from an Access database for generating graphs. An error message always pops up and says: Error message: The required OLE DB provider (Microsoft.ACE.OLEDB.12.0) for Microsoft Access is not installed  Solution: Download Microsoft Access Database Engine 2010 Redistributable … Continue reading

Posted in Access, Software, Tips | Tagged , , , , | Leave a comment

A skeleton of a MS Access VBA function operating data tables

Use Microsoft Access VBA can do all sorts of database operations. The following is the framework of a VBA subroutine. It includes all VBA database operation mechanisms. You can just borrow it and adapt it to your situation. Sub FillAField(tablename) … Continue reading

Posted in Access, VBA/ASP | Tagged , , , | Leave a comment

iPhone/iPod App to control MySQL database

In last few weeks, I reviewed several iPhone/iPod apps that can connect to MySQL server and manipulate data. My main focus are the free apps. There are a couple of free apps the emerges from the weeds. Liya Liya is … Continue reading

Posted in MySQL, Review | Tagged , , , , , , , , , | Leave a comment

Database migration: MS Access to MySQL server

The Problem Recently I solved a database migration problem: migrate MS Access database encoded in GB2312 to MySQL server encoded in UTF-8. I’d like to share what I did and hope it is useful to help you solve your problem. … Continue reading

Posted in Access, Database, MySQL, PHP | Tagged , , , , , , | 1 Comment

SQLite database engine and sample code in C#

The definition in SQLite official site is the following: “SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world.” So, how can we … Continue reading

Posted in C/C++/C#, Database | Tagged , , , , , | 1 Comment