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 :
- http://fabforce.net/dbdesigner4/
- http://prdownloads.sourceforge.net/kylixlibs/kylixlibs3-borqt-3.0-2.tar.gz?download
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 ^^