MySQL queries yeild only 10 columns.

By: Vincent Drake

Abstract: Using DBExpress to connect to MySQL and only 10 fields appear for query result. Easy solution.


Question:

My DBExpress connection to MySQL yeilds query results that return only 10 columns. What is the problem?
 
Answer:

This is usually caused by a mismatch in driver versions. Check your 'dbxdrivers.ini' file, typically found in the "/Program Files/Common Files/Borland Shared/DBExpress" folder, and make sure the driver for MySQL is "dbexpmysql.dll" and not "dbexpmys.dll". Also make sure the proper MySQL client driver 'libmysql.dll' is accessible in the system path.
 

Server Response from: ETNASC04