Skip to Content
0
Former Member
Oct 24, 2011 at 08:45 AM

ODBCINI environment variable.. (WIS 10901) from Linux > MSSQL ODBC

275 Views

Good day,

We have the following scenario. Business Objects XI 3.1, SPS 4, Explorer 3.2, SPS4. I am trying to connect to a MS SQL DB 2005 from Linux(Accelarated Explorer)

DSN created locally from WIndows Client ODBC = MS_CTSQLBIP01_BI_EXP_OLAP

Connection is exported to CMC on Explorer Linux Blade.

ODBC.ini file on Linux:

[ODBC Data Sources]

CRSQLServerWP=DataDirect 5.3 SQLServer Wire Protocol Driver

CRSybaseWP=DataDirect 5.3 Sybase Wire Protocol Driver

CRText=DataDirect 5.3 Text Driver

#%SYBASEDSN%=DataDirect 5.3 Sybase Wire Protocol Driver

MS_CTSQLBIP01_BI_EXP_OLAP=DataDirect 5.3 Sybase Wire Protocol Driver

[CRSQLServerWP]

Driver=/usr/bobj/bobje/enterprise120/linux_x86/odbc/lib/CRmsss23.so

Description=DataDirect 5.3 SQLServer Wire Protocol Driver

Address=

Database=

QuotedId=Yes

AnsiNPW=No

LogonID=

Password=

[CRSybaseWP]

Driver=/usr/bobj/bobje/enterprise120/linux_x86/odbc/lib/CRase23.so

Description=DataDirect 5.3 Sybase Wire Protocol Driver

NetworkAddress=

Database=

LogonID=

Password=

[CRText]

Driver=/usr/bobj/bobje/enterprise120/linux_x86/odbc/lib/CRtxt23.so

Description=DataDirect 5.3 Text Driver

Database=

[MS_CTSQLBIP01_BI_EXP_OLAP]

Driver=/usr/bobj/bobje/enterprise120/linux_x86/odbc/lib/libdbd_mssql.so

Description=DataDirect 5.3 MSSQL Wired Protocol Driver

NetworkAddress=CTSQLBIP01,1433

Database=BI_OLAP

LogonID=XXXXXX

Password=XXXXXXXXXX

[ODBC]

IANAAppCodePage=4

InstallDir=/usr/bobj/bobje/enterprise120/linux_x86/odbc

Trace=0

TraceFile=odbctrace.out

TraceDll=/usr/bobj/bobje/enterprise120/linux_x86/odbc/lib/odbctrac.so

I cannot validate the facets, or index the Information Space based upon the Universe, the Universe uses connection = MS_CTSQLBIP01_BI_EXP_OLAP

The error message I get is:

The database error text is: [DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment variable.. (WIS 10901))

I have tried using 2 different dll's that were delivered with the installation:

libdbd_mssql.so

and

libdbd_wmssql.so

both give the same error.

Do I need a 3rd party ODBC or can I use the ones mentioned above?

Any advice would be greatly appreciated.

Thanks

Derek