Tag Filter - (Xe)

embarcadero dbexpress SQLConnection DriverName access violation DbxCommon150.bpl

I struck a problem trying to use the dbExpress TSQLConnection components on an upgraded BDS2006 application where the program would compile and link fine but when you ran the application it would fail with the following access violation error...

Getting embarcadero dbexpress mysql working - DBX Error: Driver not initialized

Sometimes the simple things are harder than you expected and dbexpress probably comes under that category, it was less express than I had expected but once you figure things out it does work. Some of the problems were my fault while others took time due to the obscur nature of the errors returned by XE and XE2...

(default) 9 queries took 139 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `posts`171713
2DESCRIBE `comments`111125
3DESCRIBE `tags`2218
4DESCRIBE `categories`227
5DESCRIBE `posts_tags`2217
6DESCRIBE `categories_posts`226
7SELECT Post.* FROM posts Post, posts_tags pt, tags t WHERE t.tag = ('Xe') AND t.id = pt.tag_id AND pt.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC2213
8SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category15156
9SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag494934