How to Deal with Messy Codes in Essbase

最新推荐文章于 2024-12-26 16:48:51 发布

原创最新推荐文章于 2024-12-26 16:48:51 发布 · 573 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sybase #solaris #file #server #interface #dialog

2009-9 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了解决从SybaseIQ加载数据到Essbase时出现的字符显示错误问题。通过配置ODBC数据源连接并设置正确的字符集（CharSet=cp936），成功解决了乱码问题。

2009-09-23

The other day after I had loaded data into Essbase from Sybase IQ, using a rules file, I found that some characters could not be displayed correctly, such as "滘" and "邨". By the way, in order to display simplified Chinese in Essbase, I use SimplifiedChinese_China.MS936@Binary as my ESSLANG.

Well, the Essbase Server is install under the Solaris environment. And of course, we also have to configurate the ODBC data source connection. An ODBC data source connection is used to connect the database that we assigned when creating this connection. Under the Windows environment, we only need to create an ODBC connection in the "管理工具"->"数据源（ODBC）"->"系统DSN" dialog. After we click the "添加" button, a new dialog will be poped out. Then we choose "Adaptive Server IQ", because our data source is a Sybase IQ system, from which we would load data into Essbase. Click "完成", and make other relational settings in the new poping out dialog.

But in Solaris, we don't have the same graphical interface like that under Windows. As a result, we have to the same thing in a .odbc.ini file under the $HOME directory. The content of this file is as follows:

[ODBC Data Sources] IQ01=IQ ODBC Connection [IQ01] # if use IQ32bitODBC, please change the driver’s path #driver=/export/home/dtess/IQ32bitODBC/ASIQ-12_7-odbc/lib/libdbodbc9.so # if use IQ64bitODBC, please chage the driver’s path driver=/export/home/dtess/ASIQ-12_7/lib/libdbodbc9.so UID=dba PWD=SQL Servername=iqtest CharSet=cp936 CommLinks=tcpip(HOST=10.90.1.211,PORT=2688) # if IQ database’s cfg defines the DatabaseName, then need the following line #DatabaseName=iqtest

In this file, we have specified the IQ driver, username and password to connect to the Sybase IQ, servername and common links. Well, we can see the statement "CharSet=cp936", and this setting makes the messy codes problem not happen again!!!