Get the App
SLTechnology News&Howtos  ›  Database  › 

Embedded PowerPC accesses SQL Server database through unixODBC/freetds (1)

Shulou Source: shulou.com Published: 2022-06-01 20:41:36 10月03日 Update

Access the SQL SERVER database through embedded PowerPC devices, using ODBC mode.

First, cross-compile UnixODBC, the compilation process is relatively smooth

1. Download unixODBC, download path is http://www.unixodbc.org/, version number is 2.3.42, extract, tar-xvf unixODBC-2.3.4.tar.gz 3, configure compilation,. / configure-- prefix=/usr/local/unixODBC-2.3.4-- host=ppc-linux 4, compile, make 5, install, make install

Second, cross-compile freetds and encounter strange things.

1. Download freetds, ftp://ftp.freetds.org/pub/freetds/current/, version number 0.912, decompress, use 7-zip 3, configure and compile,. / configure-- host=ppc-linux-- prefix=/usr/local/freetds-0.91-- with-tdsver=7.0-- enable-msdblib-- disable-libiconv-- with-unixodbc=/usr/local/unixODBC-2.3.4 4, compile make (Note Change the name of the odbc_config under the unixODBC generation folder to solve the problem that freetds failed to compile the test file.) at first, copy the freetds to the virtual machine for compilation, and the compilation failed, prompting: / bin/sh:. / txt2man: No such file or directory error. Try to compile freetds directly from the Windows shared folder, through, Khan. 5. Install make install*** environment configuration and test to be continued! ***

Tags: Compiling files configurations folders versions crossover embedded data databases things names exotic copies ways environment devices paths procedures errors problems Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno macOS Docker NVidia Xiaomi Apple