MS SQL Server ODBC Connection On Linux

[former_member217285]

Hi All,

I am badly stuck with configuration of MS SQL Server ODBC connection on SUSE Linux 10. I am almost tried everything I got from SAP notes but still getting ODBC Lib Data Direct drivers could not be loaded IES 10901.

ENV: SAP BO 4.0 SP7, MS SQL SRV 2008

Here is what I have tried so far:

1) Modified env.sh under /install_dir/sap_bobj/setup and added the line in bold.

":${BOBJEDIR}enterprise_xi40/linux_x64/odbc/lib:${BOBJEDIR}enterprise_xi40/$SOFTWAREPATH32/odbc/lib"

The line should look like this

LIBRARYPATH="$LIBDIR:$LIBDIR32:$WCSCOMPONENTDIR:$PLUGINDIST/auth/secEnterprise:${CRPEPATH64}:${CRPEPATH}:${MWHOME}:$PLUGINDIST/desktop/CrystalEnterprise.Report:

${BOBJEDIR}enterprise_xi40/$SOFTWAREPATH32/ras:${BOBJEDIR}mysql/lib:${BOBJEDIR}enterprise_xi40/linux_x64/odbc/lib:${BOBJEDIR}enterprise_xi40/$SOFTWAREPATH32/odbc/lib”

2) We have .odbc.ini file in the home directory of our BO user on linux. Added following DSN entry (Same DSN is created on client and odbc connection has been created on the universe using this DSN:

boeadm01:~> vi .odbc.ini

[DSN_NAME]

Driver=/opt/sapboe/sap_bobj/enterprise_xi40/linux_x64/odbc/lib/CRsqls24.so

Description=DataDirect 6.0 SQL Server Native Wire Protocol

HostName=SQL Server Hostname

Database=SQL DB Name

QuotedId=Yes

AnsiNPW=No

3) We then added the environment variables and LIBPATH in BO user .profile file.

boeadm01:~> vi .profile

#Sql Server Environment

ODBCINI=$HOME/.odbc.ini

export ODBCINI

LD_LIBRARY_PATH=/opt/sapboe/sap_bobj/enterprise_xi40/linux_x64/odbc/lib

export LD_LIBRARY_PATH

4) Did echo to check the LIBPATH

boeadm01:~> echo $LD_LIBRARY_PATH

/opt/sapboe/sap_bobj/enterprise_xi40/linux_x64/odbc/lib

5) Modified sqlsrv.sbo under /install_dir/sap_bobj/enterprise_xi40/dataAccess/connectionServer/odbc

  <Parameter Name="Use DataDirect OEM Driver" Platform="Unix">Yes</Parameter>

6) Restarted BO node.

Tried creating a new webi report and got the error mentioned above.

Please help!!!

Thanks,

Anshul

[former_member197037]

Hi Anshul,

Were you able to resolve the issue?

I am in a similar fix.

Any inputs will really help.

Thanks in anticipation.

-Nagendra

[Former Member]

Hi Nagendra,

I am in similar situation. were you able to resolve it!!

Input will be of greathelp here.

Regards,

Richa

[former_member197037]

Nothing as of now.

I am planning to try JDBC now.

Do let me know if ODBC works for you.

-Nagendra

[DayaJha]

Hi Anshul,

Please refer the below KBA & SCN thread regarding your issue.

Data Direct ODBC Drivers for SAP BusinessObjects Data Services

Link:

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

Business Objects XIR2 Link:

Link:

http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/50eca18b-d13e-2b10-a8ab-973892717...

http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/20e11153-5c3f-2b10-f9be-974dc4749...

http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/70eabcba-5c64-2b10-6db2-ae28ae4d1...

http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/4039c80b-6b3f-2b10-64a4-e8e591292...

KBA:

1291142 - Web Intelligence reporting using DataDirect drivers in Unix

1292899 - Data Direct Drivers for Crystal Report in Unix environment

SQL Server ODBC Driver for Linux/Unix Getting Started Tutorial

Link:

http://www.easysoft.com/products/data_access/odbc-sql-server-driver/getting-started.html

Step by Step: Setting up Linux ODBC driver for SQL Server

Link:

http://blogs.technet.com/b/sqlman/archive/2012/08/03/step-by-step-setting-up-linux-odbc-driver-for-s...

Microsoft SQL Server ODBC driver for Linux

Link:

http://www.codesynthesis.com/~boris/blog/2011/12/02/microsoft-sql-server-odbc-driver-linux/

Thanks,

Daya