Developer Blog

I have recently been upgrading a site written in classic ASP to use MySQL instead of SQL Server - a relatively straightforward task given the availability of an ODBC driver for MySQL. Testing on our development server, the new code worked perfectly.

Once uploaded to our hosting server, however, the site no longer worked correctly. More specifically, the page that was supposed to ‘list all properties’ was reporting that there were no properties in the database. This was definitely not the case! The connection string and code were identical on our development server and the hosting server.

A little debugging showed that the ODBC driver was actually returning an empty result set (0 rows) on a particular query. Some digging through Google showed that this is a known bug in old version of the MySQL ODBC driver.

It turns out, however, that older version of this driver have an annoying bug that causes some (valid) queries to fail silently and return an empty result set.

Dan.

Encircle Marketing are a market research company specialising in the automotive aftermarket.

Acid Computer Services have designed and developed their new website.

Today we are proud to announce the launch of the new Cast UK website, for which Acid Computer Services have been solely responsible for the website development.

For recruiters, Cast UK can help with the following executive recruitment:

• Procurement Recruitment
• Supply Chain Recruitment
• Logistics Recruitment
• Engineering Recruitment
• Manufacturing Recruitment

For job seekers, Cast UK can help you find a job in the following sectors:

• Procurement Jobs
• Supply Chain Jobs
• Logistics Jobs
• Engineering Jobs
• Manufacturing Jobs