, , , 1, 1, LINUX.
-
, ! , . , 1 - . , , : MySQL PostgreSQL. LINUX ( "" - ), 1 , , PostgreSQL 1 ( Postgres PRO).
, 1, MS SQL ( Linux). , MySQL PostgreSQL .
, 1 ODBC (Open Database Connectivity, .. ). windows - - , , (, ). Linux , M$ , , . - $ apt-cahe search:
| $ apt-cache search odbc libiodbc2 - iODBC Driver Manager odbc-mdbtools - MDB tools ODBC driver odbcinst - Helper program for accessing odbc ini files odbcinst1debian2 - Support library for accessing odbc ini files unixodbc - Basic ODBC tools erlang-odbc - Erlang/OTP SQL freetds-common - FreeTDS SQL libiodbc2-dev - iODBC Driver Manager (development files) libodbc1 - ODBC Unix libreoffice-base-drivers - Database connectvity drivers for LibreOffice libreoffice-sdbc-firebird - Firebird SDBC driver for LibreOffice ... |
- -. FreeTDS - MS SQL! ...
, , , ODBC Linux. mysql :
$ sudo apt-get install libmyodbc
/etc/odbcinst.ini, :
|
[MySQL] Description = ODBC for MySQL Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so FileUsage = 1
PostgrqSQL ( ): $ sudo apt-get install odbc-postgresql |
, . MySQL :
MySQL. test, - - localhost. , "", . , , .
, , . , ( ), . "", "", "" .. .. , ... .
1 , . , :
"TestTbl". , , - , , .. , ( 1, ):
1, , , Server. .. All In One, .
PostgreSQL. , 1, PostgreSQL Unicode. :
| DRIVER={PostgreSQL Unicode};Database=jim;Server=localhost; |
, (F5) :
, , 1 . :
, 1, Linux, - - . :
- apt-cahe search ( "odbc" | grep dbname) . - .
- , /etc/odbcinst.ini . - , /usr/lib/x86_64-linux-gnu/odbc/ ( 64- , ?)
- .
- , ( ).
- - - .
- !