Mysql ODBC: Unterschied zwischen den Versionen

Aus Xinux Wiki
Zur Navigation springen Zur Suche springen
(Die Seite wurde neu angelegt: „=Download= *https://dev.mysql.com/downloads/connector/odbc/ =Install= *dpkg -i“)
 
 
Zeile 2: Zeile 2:
 
*https://dev.mysql.com/downloads/connector/odbc/
 
*https://dev.mysql.com/downloads/connector/odbc/
 
=Install=
 
=Install=
*dpkg -i
+
*dpkg -i mysql-connector-odbc_8.0.20-1ubuntu20.04_amd64.deb
 +
*dpkg -i mysql-connector-odbc-setup_8.0.20-1ubuntu20.04_amd64.deb
 +
*dpkg -i mysql-connector-odbc-dbgsym_8.0.20-1ubuntu20.04_amd64.deb
 +
=Konfiguration=
 +
*cat odbc.ini
 +
<pre>
 +
[caprica]
 +
Description          = MySQL connection to  database
 +
Driver                = MySQL-ansi
 +
Database              = covid19
 +
Server                = caprica.xinux.org
 +
User                  = root
 +
Password              = sysadm
 +
Port                  = 3306
 +
#Socket                = /var/run/mysqld/mysqld.sock
 +
</pre>
 +
*cat odbcinst.ini
 +
<pre>
 +
[MySQL-utf]
 +
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so
 +
SETUP=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8S.so
 +
UsageCount=1
 +
 
 +
[MySQL-ansi]
 +
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8a.so
 +
SETUP=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8S.so
 +
UsageCount=1
 +
</pre>

Aktuelle Version vom 22. Juni 2020, 13:27 Uhr

Download

Install

  • dpkg -i mysql-connector-odbc_8.0.20-1ubuntu20.04_amd64.deb
  • dpkg -i mysql-connector-odbc-setup_8.0.20-1ubuntu20.04_amd64.deb
  • dpkg -i mysql-connector-odbc-dbgsym_8.0.20-1ubuntu20.04_amd64.deb

Konfiguration

  • cat odbc.ini
[caprica]
Description           = MySQL connection to  database
Driver                = MySQL-ansi
Database              = covid19
Server                = caprica.xinux.org
User                  = root
Password              = sysadm
Port                  = 3306
#Socket                = /var/run/mysqld/mysqld.sock
  • cat odbcinst.ini
[MySQL-utf]
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so
SETUP=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8S.so
UsageCount=1

[MySQL-ansi]
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8a.so
SETUP=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8S.so
UsageCount=1