cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Solved with using default obdc driver CRmsss23.so delivered with install:

MS_CTSQLBIP01_BI_EXP_OLAP

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

Description=DataDirect 5.3 MSSQL Wired Protocol Driver

NetworkAddress=CTSQLBIP01,1433

Database=BI_OLAP

LogonID=XXXXXX

Password=XXXXXXXXXX

Former Member
0 Kudos

Just wanted to update, when I try index the information space, i get the following:

Server, xxxxxxxxx.PolestarIndexing, generated the following messages:

Index Creation Failed (The execution of the specified analysis query failed.-The Web Intelligence server cannot be reached. Contact your Business Objects administrator. (Error: RWI 00236))

My webintelligenceprocessingserver is running OK.

If I try run a query, connecting via Webi:

A database error occured. The database error text is: [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.. (WIS 10901)

Looks like it is related to the odbc libraries in Linux, anyone had similar issues along these lines?

Thanks

Derek