🚀 go-pugleaf

I am trying to use mysql db in a Cbuilder 6 app.  from what I have read I
should use DBExpress.
So I did the following.
Created a SQLConnection with the following properties
Connected - false
ConnectionName - MSConnection
DriverName - MYSQL
GetDriverFunction - getSQLDriverMYSQL
Keep Connection - true
LibraryName - dbexpmys.dll
LoadParamsonConnect - false
LoginPrompt - true
Name - SQLConnection1
Params - none
VendorLib - LIBMYSQL.dll

then i created a TSQLTable object with the following properties
Name - SQLTable1
NoMetaData - false
ObjectView - false
SQLConnection - SQLConnection1   --->pointing to the SQLCONNECTION object I
jsut created above
tableName - C:\mysql\data\test\appusernames.frm



when I try to set the table to active I get a password prompt.  no matter
what I put in here I get an error message "DBX Error: Invalid
Username/Password"
since this is the test database it shouldnt even need a password.  so I set
the loginprompt field to FALSE and I still get the error message.

Does anyone know what I am doing wrong?  if not, does anyone have CBuilder6
working with mysql and if so, how did you set it up???

HELP!