Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

Hello all,

I want to provide you the required steps (with the help of my colleagues from team) in order to create a connection between a SAP system running on Linux (SuSe in my case) and external SQL server. For the SAP system level configuration (DBCO transaction entry needed), you can check the note 178949 - MSSQL: Database MultiConnect . Main note for this activity: 1644499 - Database connectivity from Linux to SQL Server

My Linux version:

root-> cat /etc/SuSE-release

SUSE Linux Enterprise Server 11 (x86_64)

VERSION = 11

PATCHLEVEL = 4

1- Check you SAP Kernel, if dbmssslib.so file is in place. Make sure that mentioned packages in the note already installed:

root-> cd /sapmnt/SID/exe/uc/linuxx86_64/

root-> ls -ltr dbmssslib.so

-rwxr-xr-x 1 sidadm sapsys 1820217 Oct 30  2015 dbmssslib.so

root-> rpm -q glibc

glibc-2.11.3-17.90.4

....

2- Download ODBC Driver from this address:


3- Download unixODBC component from this address:


4- Create a temporary directory and copy those 2 downloaded files there. Then extract and build in following order:

root-> mkdir /tmp/MSSQL_ODBC

root-> gunzip msodbcsql-11.0.2260.0.tar.gz

Copy unixODBC under the new folder:

root-> cp unixODBC-2.3.0.tar.gz ./msodbcsql-11.0.2260.0/

Build it:

root-> cd ./msodbcsql-11.0.2260.0

root-> ./build_dm.sh --download-url=file://unixODBC-2.3.0.tar.gz

5- Install unixODBC:

root-> cd /tmp/unixODBC.10010.13772.354/unixODBC-2.3.0

root-> make install

Making install in extras

make[1]: Entering directory `/tmp/unixODBC.10010.13772.354/unixODBC-2.3.0/extras'

make[2]: Entering directory `/tmp/unixODBC.10010.13772.354/unixODBC-2.3.0/extras'

make[2]: Nothing to be done for `install-exec-am'.

root-> ./install.sh verify

root-> ./install.sh install --force

Check if ODBC properly installed:

root-> odbcinst -q -d -n "ODBC Driver 11 for SQL Server"

[ODBC Driver 11 for SQL Server]

Description=Microsoft ODBC Driver 11 for SQL Server

Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2260.0

Threading=1

UsageCount=1

You can execute ADBC_TEST_CONNECTION report for testing the connection:

Other useful links and even a video from SAP:

http://scn.sap.com/community/hana-in-memory/blog/2016/04/15/microsoft-odbc-driver-for-sql-server-on-...

https://www.youtube.com/watch?v=npgNjSNXG2Q

http://scn.sap.com/docs/DOC-68640

http://scn.sap.com/docs/DOC-56997

http://scn.sap.com/community/sqlserver/blog/2013/01/19/how-to-access-an-external-microsoft-sql-serve...

http://help.sap.com/saphelp_hana_options_sds_conf/helpdata/en/e7/83b19c6f0f10149a438f15eda0ba9f/cont...

Labels in this area