How to install DBDesigner 4

Hey !

Today I will explain how to install dbdesigner4 on Fedora. It's a bit tricky ! :/

So first of all, download these two files :

After, extract dbdesigner (tar -xvzf DBDesigner4.0.5.4.tar.gz).

Extract also kylixlibs3-borqt-3.0-2.tar.gz.

Go to the kylixlibs3-borqt folder, and do this :

tar -xvzf DBDesigner4.0.5.4.tar.gz
tar -xvzf kylixlibs3-borqt-3.0-2.tar.gz
cd kylixlibs3-borqt
su -
cp libborqt-6.9.0-qt2.3.so /usr/lib/libborqt-6.9.0-qt2.3.so
ln -s /usr/lib/libborqt-6.9.0-qt2.3.so /lib/libborqt-6.9-qt2.3.so
/sbin/ldconfig
chown -R user:user ../DBDesigner4
cd ../DBDesigner4/
./startdbd

And thats it ! :)

But now, you want to connect DBDesigner to your database to automatically manage your table from your design ! And apparently It doesn't work !

Okay, okay, I give you the solution !

Donwload this file :
http://www.devart.com/dbx/download.html (the right for you, sure !)

Extract it and copy it to /usr/lib :

tar -xvzf dbxmda.tar.gz
su -
cd DbxMda
mv libsqlmda.so.4.20 /usr/lib/

Then, open DBDesigner, go to Database > Connect to Database, click on "New connection Database", choose the "advance" tab, and modify these informations :

LibraryName: libsqlmda.so.4.60
VendorLib: libmysqlclient.so.10.0.0
GetDriverFunc: getSQLDriverMySQL

BE CAREFUL ! The current value for GetDriverFunc is NOT the same as the one indicated here ! Yep ! The Y is in upper caps but mine is in lower caps. It's a big difference because in the libsqlmda.so, the function is getSQLDriverMySQL and NOT getSQLDriverMYSQL, so if you leave the Y, it will not work ! :p

Now you can play with mysql ^^

Posted by Cyril Nicodème