Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
devuan-3-how-to-advanced2-odbc-venenux [2017/06/03 23:55] mckaygerhard [2) install and prepare sqlite odbc] |
devuan-3-how-to-advanced2-odbc-venenux [2017/06/05 13:44] (current) mckaygerhard sqlite odbc no in devuan, freetds out of date, mdbtools odbc but lack documentation |
||
|---|---|---|---|
| Line 315: | Line 315: | ||
| ===== 2) install and prepare sqlite odbc ===== | ===== 2) install and prepare sqlite odbc ===== | ||
| - | First install the odbc driver module and the sqlite manager packages, the package will register a driver module named "SQlite3" and another named "SQlite" for sqlite versions 3 and 2 respectively: | + | First install the odbc driver module and the sqlite manager packages are not in default Devuan repositories for some reason does not auto mirror, so added a Debian repository temporally and then removeit. |
| - | apt-get install unixodbc odbcinst odbcinst1debian2 libsqliteodbc sqlite3 sqlite | + | apt-get install unixodbc odbcinst odbcinst1debian2 |
| + | |||
| + | While the Debian repository are temporally active, install the respective sqlite odbc packages, the package will register a driver module named "SQlite3" and another named "SQlite" for sqlite versions 3 and 2 respectively: | ||
| + | |||
| + | apt-get install libsqliteodbc sqlite3 sqlite | ||
| If all are good, will registered automatically the SQLite and SQLite3 driver modules for usage and console will outputs: | If all are good, will registered automatically the SQLite and SQLite3 driver modules for usage and console will outputs: | ||
| Line 327: | Line 331: | ||
| odbcinst: Driver installed. Usage count increased to 1. | odbcinst: Driver installed. Usage count increased to 1. | ||
| Target directory is /etc | Target directory is /etc | ||
| + | |||
| + | Now remove the Debian repositories and proceed with proper ODBC task. | ||
| Create a testdb.sqlite database, then create a table "tabla1" with one column "col1" and then type ".quit" to exit: | Create a testdb.sqlite database, then create a table "tabla1" with one column "col1" and then type ".quit" to exit: | ||
| Line 446: | Line 452: | ||
| * The Server parameter are important, must be ip address of the target DBMS, here we emulate remote server as "localhost" or "127.0.0.1" for connected database, please never use "Servername" parameter. | * The Server parameter are important, must be ip address of the target DBMS, here we emulate remote server as "localhost" or "127.0.0.1" for connected database, please never use "Servername" parameter. | ||
| * The isql command line invocation its just only for test or DSN odbc access using the DSN odbc name, the ODBC DSN name are "odbcmysql" and will define the odbc.ini section of the DSN overall for specific database type. | * The isql command line invocation its just only for test or DSN odbc access using the DSN odbc name, the ODBC DSN name are "odbcmysql" and will define the odbc.ini section of the DSN overall for specific database type. | ||
| + | |||
| ===== 5) install and prepare freetds odbc ===== | ===== 5) install and prepare freetds odbc ===== | ||
| + | |||
| + | Freetds Debian/Devuan package are very out of date, due up to date added support for ''nvarchar'', ''nchar'' and ''ntext'' sql types, very important for Sybase proxy tables and Unicode support due the size of the variables there's a implicit convertion. | ||
| + | |||
| + | ===== 6) install and prepare mdbtools odbc ===== | ||
| + | |||
| + | The MDBTools project provide and ODBC driver module.. but are poor documented and Devuan package does not offer any improvement over documentation.. its like there-s no package at all. | ||
| + | |||
