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.


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

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