dbdesigner
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
dbdesigner [2006/06/19 15:37] – 65.117.185.97 | dbdesigner [2007/11/06 21:02] (current) – 189.11.236.216 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== DBDesigner on Debian ====== | ||
+ | // Outflank the problem! Alternative solution, use wine! // | ||
+ | In fact, I'd like to recommand strongly to use wine and the Windows installer. It will save you a lot of time with the configuration and the user interface will be nicer:-) | ||
+ | |||
+ | I have put some details on my blog: | ||
+ | http:// | ||
+ | |||
+ | [[http:// | ||
+ | |||
+ | == Update by Danilo Cesar == | ||
+ | |||
+ | I think that some people will have some problems with new windows under wine that dont get focus. I solve this problem with devilspie and a little script under it. You can find it on: http:// | ||
+ | |||
+ | // | ||
+ | ---- | ||
+ | |||
+ | |||
+ | === From Martin === | ||
+ | I can confirm that - I went both ways, and Wine one (actually, I used CrossOver for Linux) is much easier and has better results. | ||
+ | Martin | ||
+ | === | ||
+ | |||
+ | ===From Marcio === | ||
+ | Come here: http:// | ||
+ | Marcio | ||
+ | === | ||
+ | |||
+ | ===== WORK IN PROGRESS ===== | ||
+ | |||
+ | [[http:// | ||
+ | |||
+ | Get the .tgz from the [[http:// | ||
+ | |||
+ | It needs a shared library from Kylix: | ||
+ | |||
+ | libborqt-6.9-qt2.3.so: | ||
+ | |||
+ | Get it from the [[http:// | ||
+ | |||
+ | $> wget http:// | ||
+ | #> dpkg -i kylixlibs3-borqt_3.0-1_i386.deb | ||
+ | |||
+ | Then make a symbolic link to the lib and do ldconfig: | ||
+ | #> cd /usr/lib | ||
+ | #> ln -s kylix3/ | ||
+ | #> ldconfig | ||
+ | |||
+ | It also needs a c++ shared library: | ||
+ | $> | ||
+ | (nothing happens) | ||
+ | $>cat ~/ | ||
+ | $> | ||
+ | $> | ||
+ | |||
+ | (Running Debian sarge, I found that this was sufficient to get the application started (this is | ||
+ | DBDesigner 4.0.5.4 Beta). | ||
+ | |||
+ | |||
+ | With regards to // | ||
+ | |||
+ | #> ln -s / | ||
+ | |||
+ | Thereafter, DBDesigner started up. I see now, though, that I have to resolve the '' | ||
+ | |||
+ | http:// | ||
+ | |||
+ | $> ls -l /var/log | ||
+ | |||
+ | more kylix libs needed: http:// | ||
+ | |||
+ | ===== Using ODBC ===== | ||
+ | |||
+ | UnixODBC is available from http:// | ||
+ | |||
+ | #> apt-get install unixodbc unixodbc-bin | ||
+ | |||
+ | The next thing needed is an ODBC driver for MySQL which is available as binary package from http:// | ||
+ | |||
+ | $> wget http:// | ||
+ | $> tar -xzvf MyODBC-3.51.07-pc-linux-i686.tar.gz | ||
+ | $> cd MyODBC-3.51.07-pc-linux-i686 | ||
+ | $> rm -f libmyodbc3 libmyodbc3_r | ||
+ | $> ln -s libmyodbc3-3.51.07 libmyodbc3 | ||
+ | $> ln -s libmyodbc3_r-3.51.07 libmyodbc3_r | ||
+ | #> cp -a libmyodbc* / | ||
+ | ---- | ||
+ | |||
+ | I am running debian unstable and after doing all the above, I still got | ||
+ | |||
+ | libborqt-6.9-qt2.3.so: | ||
+ | |||
+ | Finally fixed everything when I got an rpm and converted it to deb with the program alien | ||
+ | |||
+ | libborqt-6.9.0-2.i386.rpm can be downloaded from : | ||
+ | |||
+ | http:// | ||
+ | |||
+ | Convert to deb file with alien and then install it. | ||
+ | |||
+ | #> alien libborqt-6.9.0-2.i386.rpm | ||
+ | #> dpkg -i libborqt_6.9.0-3_i386.deb | ||
+ | |||
+ | Sarge does work with the libborqt_6.9.0-3_i386.deb from | ||
+ | http:// | ||
+ | |||
+ | The rpm seems to be working for Mandrakelinux 10.x too. | ||
+ | |||
+ | Same problem under Ubuntu 5.04 too. I downloaded libborqt_6.9.0-3_i386.deb from http:// | ||
+ | |||
+ | On Debian unstable (sid), I had to install the following package and libborqt-6.9.0-2: | ||
+ | http:// | ||
+ | |||
+ | Download the package from the URL above and install it with dpkg. | ||
+ | |||
+ | |||
+ | ===== Problems with libsqlmy.so ===== | ||
+ | |||
+ | After following the previous steps in debian sarge I can't use ./startdbd to run the application; | ||
+ | |||
+ | Thanks you very much. | ||
+ | |||
+ | Lbracci@cantv.net | ||
+ | |||
+ | I had the same problem | ||
+ | |||
+ | cmorel@ecnex.com | ||
+ | |||
+ | I had the same problem...and here is the fix: I installed the dbexpress library: download the .tar.gz, copied file libsqlmda.so.2.60 (or 3.10 that is a newer version) to /usr/lib and execute ldconfig. | ||
+ | |||
+ | [[http:// | ||
+ | |||
+ | Then I went to DBDesigner4 -> Database -> Connect to database. Click on "New Database Connection", | ||
+ | * LibraryName: | ||
+ | * VendorLib: libmysqlclient.so.10.0.0 | ||
+ | * GetDriverFunc: | ||
+ | |||
+ | Please note that by default the GetDriverFunc is " | ||
+ | |||
+ | # objdump -TC linsqlmda.so.2.60 | ||
+ | |||
+ | you'll see what I mean) | ||
+ | |||
+ | apatruduque | ||
+ | |||
+ | |||
+ | |||
+ | For a more permanent option, find the [Installation directory]/ | ||
+ | |||
+ | paul | ||
+ | |||
+ | ===================USING XSLT for reporting====== | ||
+ | ecause Dbdesigner saves in xml format you can use any xsltprocessor for reporting or for inclusing in your documentation, | ||
+ | just an example I used the Example/ | ||
+ | to create the html page do | ||
+ | | ||
+ | |||
+ | < | ||
+ | < | ||
+ | xmlns: | ||
+ | < | ||
+ | |||
+ | <xsl:key name=" | ||
+ | <xsl:key name=" | ||
+ | <xsl:key name=" | ||
+ | <xsl:key name=" | ||
+ | <xsl:key name=" | ||
+ | |||
+ | |||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | function toggle(id){ | ||
+ | var el = document.getElementById(id); | ||
+ | if (el.style.display == ' | ||
+ | el.style.display = ' | ||
+ | else | ||
+ | el.style.display = ' | ||
+ | } | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | <body bgcolor=" | ||
+ | < | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | <table border=" | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | < | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | |||
+ | <tr> | ||
+ | <td span=" | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | < | ||
+ | < | ||
+ | <a href=" | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | <tr> | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | </ | ||
+ | < | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | <table border=" | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | </ | ||
+ | |||
+ | < | ||
+ | <tr> | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | < | ||
+ | </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | ---------- end order.xsl ----------> | ||
+ | |||
+ | Have fun Rene |
dbdesigner.txt · Last modified: 2007/11/06 21:02 by 189.11.236.216