Oracle Enterprise Linux installtion instruction

[elico]

I have followed Microsoft instructions on how to install FreeTDS and tiny_tds on RHEL and tried to use it both on RHEL 8 and Oracle Enterprise Linux 8. With the docs from MS at:

• https://www.microsoft.com/en-us/sql-server/developer-get-started/ruby/rhel/?rtc=1
• https://docs.microsoft.com/en-us/sql/connect/ruby/step-3-proof-of-concept-connecting-to-sql-using-ruby?view=sql-server-ver16

It wasn't possible to make ruby talk to the DB server. The first thing is that on RHEL and Oracle Enterprise Linux 8 you need to enable code ready builder repository using: dnf config-manager --set-enabled ol8_codeready_builder or subscription-manager repos --enable codeready-builder-for-rhel-8-x86_64-rpms

Then install the dependencies using: dnf install -y git-core zlib zlib-devel gcc-c++ patch readline readline-devel libyaml-devel libffi-devel openssl-devel make bzip2 autoconf automake libtool bison curl sqlite-devel

The first thing is that the installation of FreeTDS is done using: ./configure --prefix=/usr/local --with-tdsver=7.3 Which is the wrong way... and it should be: ./configure --prefix=/usr

and then run install FreeTDS with: make && make install

And just to clear out that the current FreeTDS I have tested it with is: http://ftp.freetds.org/pub/freetds/stable/freetds-1.3.12.tar.gz

Some of the issues are that the lib....so is missing from Ruby point of view.

In ruby it was pretty simple: gem install tiny_tds

and if any error arise google was not helpful enough... so.. here the issue.

[elico]

HTH