Needed to rename libmysql50.dll to libmysqld50.dll

[krisleech]

The MySQL DLL's in /lib are called things like libmysql50.dll but when I tried to connect to the database it gave an excpetion saying it could not find libmysqld50.dll, I copied the MySQL DLL's to the app folder, system and system32, but it was not until I started to type the exception in to my forum post I realised the dll it could not find had an extra character, 'd' . I renamed the DLL to be the same and it worked...

It could be that I have had two versions of ZeosLib installed.

When I try and connect a table I get an error saying "SQL Error: No database selected".

[zippo]

Could be that you selected an embedded version of MySQL by mistake?

[paranjun]

In ObjectInspector,

ZConnection1.Database <- Database name

You don't select file in database property. Just input database name.

ZConnection1.Category is not necessary.