Panda-Sql installation on Linux via Wine


Panda-Sql 3.0.0  is running  natively on  Linux via Wine 1.6 (or later version).  The interface with LibreOffice Calc is provided by copy / paste of the queries result.





ScreenShot of Panda-Sql on Linux Mint 17.3 Cinnamon 32bit and wine 1.6.

Installation Steps on Linux Mint / Ubuntu*:

Install "wine" 1.6:

Open a terminal window  [CTRL] + [ALT] + [T] and run the next commands :

sudo add-apt-repository ppa:ubuntu-wine/ppa
sudo apt-get update
sudo apt-get install wine1.6
sudo apt-get install winetricks

Run command:

winetricks mdac28 corefonts

To complete the wine installation, once open the wine configuration utility, then close:

winecfg

For details on the wine installation see page: https://doc.ubuntu-fr.org/wine


Install "Panda-Sql" 3.0.0:

Go to  the wine directory corresponding to drive "C:" and create directory "download" for programs to install:

cd ~/.wine/dosdevices/c:
mkdir download
cd download

Unzip in directory "~/.wine/dosdevices/c:/download"  the installation setup  of panda-sql "Panda-Sql_3.0.0-Win32_Setup.exe", and then run install Panda-Sql 3.0.0:

wine Panda-Sql_3.0.0-Win32_Setup.exe

Edit the file "Panda.ini" and change the font for Linux (the default font "MS Sans Serif" is not very good under linux) :

[PARAMETRES]
FORM_FONT_NAME=Tahoma

Run Panda-Sql 3.0.0:

cd ~/.wine/dosdevices/c:/"Program Files"/Panda
wine Panda.exe

You can then use the Panda-Sql desktop icon


Configure connectors:

Mysql:

The standard mysql connections work without additional operation.


Mysql via odbc:

Download the mysql odbc driver for Windows 5.2.7:  :  https://dev.mysql.com/downloads/connector/odbc/
Install the driver odbc for windows, ex:

wine msiexec /i mysql-connector-odbc-5.2.7-win32.msi

Configure MySql odbc connections.

wine  odbcad32.exe


Mssql  (Sql Server):

Configure MSSQL connections, the driver is preinstalled:

wine  odbcad32.exe


Pgsql  (PostgreSql):


Download the pgsql odbc driver for Windows   https://www.postgresql.org/ftp/odbc/versions/msi/
Install the driver odbc for windows, ex:

wine msiexec /i  psqlodbc_x86.msi

Configure PgSql odbc connections:

wine  odbcad32.exe


SqLite:

Download the sqlite odbc driver for Windows:  http://www.ch-werner.de/sqliteodbc/
Install the sqlite odbc driver for windows, ex:

wine sqliteodbc.exe


Oracle:

Download the Oracle 32 bits client 11Gr2 for windows::  http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html
Unzip Oracle client in directory   "~/.wine/dosdevices/c:/download/client",  then run Oracle installer.

cd ~/.wine/dosdevices/c:/download/client
wine setup.exe

Choose "RunTime" installation type.


Choose destination directories.




The verification phase systematically fails, go ahead and click the box "Ignore all".



Run installation.


Copy or edit the "tnsnames.ora" file in directory "~/.wine/dosdevices/c:/oracle/product/11.2.0/client_1/network/admin".