|
It is not easy to move the database under WINDOWS to LINUX to be accessed Encountered N strange errors in the middle The experience of failure is recalled as follows: Use yum install freetds* yum installunixODbc* The components installed by this method seem unreliable I got hand-loaded There are also 64-bit machines that don't have the same location as the one mentioned in the official readme.1st. (I'm going!) ) Here are some steps copied from history (slightly sorted out) cd freetds-0.91/ ./configure --prefix=/etc/freetds --with-tdsver=8.0 --enable-msdblib --enable-dbmfix --with-gnu-ld --enable-shared --enable-static make make install tsql -S172.16.1.10 -U testdba -P ak51ak vi /usr/local/freetds/etc/freetds.conf wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.1.tar.gz tar zxvf unixODBC-2.3.1.tar cd unixODBC-2.3.1 ll ./configure make make install odbcinst -j wget http://pyodbc.googlecode.com/files/pyodbc-3.0.6.zip unzip pyodbc-3.0.6.zip cd pyodbc-3.0.6 python setup.py build python setup.py install
vi /etc/odbcinst.ini ls /usr/lib64/libtdsodbc.so.0 cd /usr/lib64 ll libtds* vim /etc/odbc.ini vi /etc/odbcinst.ini
[SQL Server] Description = FreeTDS ODBC driver for MSSQL Driver = /usr/lib64/libtdsodbc.so.0 Setup = /usr/lib64/libtdsS.so.0 FileUsage = 1
|