Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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 ​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 mirrorso added 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.
 +