informix 11.5 for windows的ODBC和JDBC连接使用问题
本帖最后由 eternalfaith 于 2011-06-01 17:21 编辑首先说一下ODBC数据源配置问题,点击ODBC数据源配置时会报Unspecified System Error = -23101
http://my.chinaunix.net/attachment/201106/1/25894070_1306919694YJRJ.jpg
ODBC数据源中配置environment选项卡中的DataBase Locale却是不可修改的,情况如下:
http://my.chinaunix.net/attachment/201106/1/25894070_13069196948Aao.jpg
1、我安装的组件有
http://my.chinaunix.net/attachment/201106/1/25894070_1306919693Chww.jpg
2、安装完成后我在Setnet32中配置了:
Client_LOCALE=EN_US.CP1252
DB_LOCALE=EN_US.CP1252
DBTEMP=C:\Program Files\IBM\IBM Informix Dynamic Server\11.50\INFXTMP
INFORMIXDIR=C:\Program Files\IBM\Informix\Client-SDK\
INFORMIXSERVER=ol_svr_xedoc
3、我用onstat -g env查看服务器环境变量如下:但设置的DB_LOCALE好像并没有起作用
C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set CLASSPATH=C:\PROGRA~1
\IBM\IBMINF~1\11.50\extend\krakatoa\krakatoa.jar;C:\PROGRA~1\IBM\IBMINF~1\11.50\
extend\krakatoa\jdbc.jar;
C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set DBTEMP=C:\PROGRA~1\IB
M\IBMINF~1\11.50\infxtmp
C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set CLIENT_LOCALE=EN_US.C
P1252
C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>set DB_LOCALE=EN_US.CP125
2
C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>mode con codepage select=
1252
Status for device CON:
----------------------
Lines: 300
Columns: 80
Keyboard rate:31
Keyboard delay: 1
Code page: 1252
C:\Program Files\IBM\IBM Informix Dynamic Server\11.50>onstat -g env
IBM Informix Dynamic Server Version 11.50.TC7DE -- On-Line -- Up 00:01:42 -- 7
8208 Kbytes
Server start-up environment:
Variable Value
CLIENT_LOCALE EN_US.CP1252
COMSPEC C:\WINDOWS\system32\cmd.exe
DBDELIMITER |
DBLANG EN_US.CP1252
DBPATH .
DBPRINT lpr
DBTEMP /tmp
DB_LOCALE EN_US.8859-1
INFORMIXDIR C:\PROGRA~1\IBM\IBMINF~1\11.50
INFORMIXSERVER ol_svr_xedoc
INFORMIXTERM terminfo
LC_COLLATE en_us.8859-1
LC_CTYPE en_us.8859-1
LC_MONETARY en_us.8859-1
LC_NUMERIC en_us.8859-1
LC_TIME en_us.8859-1
LKNOTIFY yes
LOCKDOWN no
NODEFDAC no
ONCONFIG ONCONFIG.ol_svr_xedoc
PATH F:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WI
NDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Intel\DMIX
;C:\Program Files\EgisTec BioExcess\;C:\Program Files\Tort
oiseSVN\bin;C:\Program Files\Microsoft SQL Server\80\Tools
\BINN;C:\PROGRA~1\ibm\gsk7\bin;C:\PROGRA~1\ibm\gsk7\lib;C:
\Program Files\ibm\gsk7\bin;C:\Program Files\ibm\gsk7\lib;
C:\Sybase\shared;C:\Program Files\Informix\Connect\bin;C:\
Program Files\IBM\Informix\Client-SDK\bin;;F:\INFORMIX\bin
SERVER_LOCALE EN_US.CP1252
TERM dumb
TERMCAP /etc/termcap
问题和此贴基本相同,但是那贴中没有解决http://bbs.chinaunix.net/thread-1834013-1-1.html
求教~~~~~~ JDBC的问题就是取不到Connection,我看一下实例的日志,里面有链接限制的问题,我把服务器连接池的连接数改小了也不行,问题日志如下:
17:22:06Warning: The IBM IDS Developer Edition license restriction limits
17:22:06the number of connections to this server to 20.
17:22:06You already have 20 connections at this time. Any further connections
17:22:06attempts will be rejected.
链接数限制我是无法修改的吗?20可够小的 JDBC的问题就是取不到Connection,我看一下实例的日志,里面有链接限制的问题,我把服务器连接池的连接数改小了也不行,问题日志如下:
17:22:06Warning: The IBM IDS Developer Edition license restriction limits
17:22:06the number of connections to this server to 20.
17:22:06You already have 20 connections at this time. Any further connections
17:22:06attempts will be rejected.
链接数限制我是无法修改的吗?20可够小的
页:
[1]