ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » [DataDirect][ODBC lib] Specified driver could not be loaded

Post new topic  Reply to topic
 [DataDirect][ODBC lib] Specified driver could not be loaded « View previous topic :: View next topic » 
Author Message
vallu
PostPosted: Mon Apr 14, 2008 12:58 pm    Post subject: [DataDirect][ODBC lib] Specified driver could not be loaded Reply with quote

Apprentice

Joined: 29 Jun 2002
Posts: 31
using wmb6.1 with broker db on DB2 v9.1. Broker is running properly. Wanted to connect to a user database, on oracle 10g. Installed oracle client on local machine and sqlplus works good.

Have tried all the options on this forum. Below is our environment. We get an error that driver cannot be loaded. Pleae help

+++++++++++++++
_=/usr/bin/env
MANPATH=:/usr/dt/man
LANG=en_US
LOGIN=eqwbi0
SSH_TTY=/dev/pts/0
PATH=/usr/opt/mqsi/6.1/jre15/ppc64/bin:/usr/opt/mqsi/6.1/bin:/u01/oracle/product/10.2/bin:/etc:/usr/bin:/usr/lbin:/usr/local/bin:.:/usr/opt/mqsi/6.1/jre15/ppc64/bin:/usr/opt/mqsi/6.1/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/eqwbi0/bin:/usr/bin/X11:/sbin:.:.:/u01/oracle/product/10.2/bin:/usr/opt/mqsi/6.1/bin:/usr/mqm/java/lib64:/usr/opt/IBM/WebSphereAdapters/bin:/usr/opt/IBM/WebSphereAdapters/AdapterJRE/bin:/usr/java14/bin:/usr/java14/jre/bin:/home/db2wbstg/sqllib/bin:/home/db2wbstg/sqllib/adm:/home/db2wbstg/sqllib/misc
LIL=/usr/opt/mqsi/classes
MQSI_JARPATH=/usr/opt/mqsi/6.1/classes:/usr/opt/mqsi/6.1/messages:/usr/opt/mqsi/6.1/classes:/usr/opt/mqsi/6.1/messages
LC_ALL=en_US
ORACLE_BASE=/u01/oracle
OH=/u01/oracle/product/10.2
LC__FASTMSG=false
MQSI_REGISTRY=/var/mqsi
CLASSPATH=/usr/opt/mqsi/6.1/classes/derby.jar:/usr/opt/mqsi/6.1/classes/ConfigManagerProxy.jar:/usr/opt/mqsi/6.1/classes/configutil.jar:/usr/mqm/java/lib/com.ibm.mq.jar:/usr/mqm/java/lib/connector.jar:/usr/opt/mqsi/6.1/messages:/u01/oracle/product/10.2/jdbc/lib/classes12.zip:.:/usr/opt/mqsi/6.1/classes/derby.jar:/usr/opt/mqsi/6.1/classes/ConfigManagerProxy.jar:/usr/opt/mqsi/6.1/classes/configutil.jar:/usr/mqm/java/lib/com.ibm.mq.jar:/usr/mqm/java/lib/connector.jar:/usr/opt/mqsi/6.1/messages:/usr/java14/lib:/usr/java14/jre/lib:/usr/java14/bin:/usr/java14/jre/bin:/usr/mqm/java/lib/com.ibm.mq.jar:/usr/mqm/java/lib/com.ibm.mqbind.jar:/usr/mqm/java/lib/connector.jar:/usr/mqm/java/lib/jms.jar:/usr/mqm/java/lib/rmm.jar:/usr/mqm/java/lib/fscontext.jar:/usr/mqm/java/lib/jndi.jar:/usr/mqm/java/lib/com.ibm.mqjms.jar:/usr/mqm/java/lib/jta.jar:/usr/mqm/java/lib/providerutil.jar:/usr/mqm/java/lib/ldap.jar:/usr/opt/mqsi/6.1/classes/jplugin2.jar:/usr/opt/mqsi/6.1/classes/activation.jar:/usr/opt/mqsi/6.1/classes/mail.jar:/usr/opt/mqsi/6.1/classes:/usr/opt/mqsi/6.1/classes/jt400.jar:/usr/opt/mqsi/6.1/classes/ftp.jar:/usr/opt/mqsi/6.1/classes/classes12.jar:/usr/opt/mqsi/6.1/classes/ant.jar:/usr/opt/IBM/WebSphereAdapters/lib/commons-net-1.4.0.jar:/usr/opt/IBM/WebSphereAdapters/lib/jakarta-oro.jar:/usr/opt/mqsi/6.1/classes/ConfigManagerProxy.jar:/home/db2wbstg/sqllib/java/db2java.zip:/home/db2wbstg/sqllib/java/db2jcc.jar:/home/db2wbstg/sqllib/java/sqlj.zip:/home/db2wbstg/sqllib/function:/home/db2wbstg/sqllib/java/db2jcc_license_cu.jar:.
LOGNAME=eqwbi0
MQSI_FAD=4
MAIL=/usr/spool/mail/eqwbi0
DISTHUB_PATH=/usr/opt/mqsi/6.1
EXTSHM=ON
LOCPATH=/usr/lib/nls/loc
MQSI_JREPATH=/usr/opt/mqsi/6.1/jre15
MQSI_DEVELOPMENT=/var/mqsi/registry
USER=eqwbi0
AUTHSTATE=compat
LC_MESSAGES=en_US
MQSI_LILPATH64=/usr/opt/mqsi/6.1/lil:/usr/opt/mqsi/6.1/jplugin:/usr/opt/mqsi/6.1/lil:/usr/opt/mqsi/6.1/jplugin
wadapters=/usr/opt/IBM/WebSphereAdapters
MQSI_VERSION=6.1.0.0
MQSI_CATALINA_HOME=/usr/opt/mqsi/6.1/catalina
SHELL=/usr/bin/ksh
ODMDIR=/etc/objrepos
MQSI_FILEPATH=/usr/opt/mqsi/6.1
ORA_NLS33=/u01/oracle/product/10.2/nls/data
MQSI_SECURITY_PROVIDER_PATH32=/usr/opt/mqsi/6.1/SecurityProviders32:/usr/opt/mqsi/6.1/SecurityProviders32
ODBCINI=/var/mqsi/odbc/odbc64.ini
HOME=/home/eqwbi0
MQSI_VERSION_F=0
ODBCINI64=/var/mqsi/odbc/odbc64.ini
MQSI_WORKPATH=/var/mqsi
MQSI_LILPATH32=/usr/opt/mqsi/6.1/lil32:/usr/opt/mqsi/6.1/jplugin:/usr/opt/mqsi/6.1/lil32:/usr/opt/mqsi/6.1/jplugin
DB2INSTANCE=db2wbstg
SSH_CONNECTION=144.93.227.177 3096 10.20.26.142 22
SSH_CLIENT=144.93.227.177 3096 22
MQSI_EXMLTCONFIGPATH=/usr/opt/mqsi/6.1/exmltConfig
TERM=vt100
MAILMSG=[YOU HAVE NEW MAIL]
ORACLE_HOME=/u01/oracle/product/10.2
MQSI_VERSION_M=0
PWD=/home/eqwbi0
clogs=/usr/opt/IBM/WebSphereAdapters/logs
MQSI_THREAD_STACK_SIZE=2000000
TZ=PST8PDT
MQSI_LIBPATH32=/usr/opt/mqsi/6.1/jre15/bin:/usr/opt/mqsi/6.1/jre15/bin/classic:/usr/mqm/lib:/usr/opt/mqsi/6.1/ODBC32/V5.2/lib:/usr/opt/mqsi/6.1/xml4c/lib:/usr/opt/mqsi/6.1/xlxpc/lib
MQSI_VERSION_V=6
ORAENV_ASK=yes
MQSI_SECURITY_PROVIDER_PATH64=/usr/opt/mqsi/6.1/SecurityProviders:/usr/opt/mqsi/6.1/SecurityProviders
MQSI_VERSION_R=1
A__z=! LOGNAME
NLSPATH=/usr/opt/mqsi/6.1/messages/%L/%N:/usr/opt/mqsi/6.1/messages/En_US/%N:/usr/opt/mqsi/6.1/messages/%L/%N:/usr/opt/mqsi/6.1/messages/En_US/%N:/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/en_US/%N:/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat:/usr/opt/mqsi/messages/%N
LIBPATH=/usr/opt/mqsi/6.1/jre15/ppc64/bin:/usr/opt/mqsi/6.1/jre15/ppc64/bin/classic:/usr/mqm/java/lib64:/usr/mqm/lib64:/usr/opt/mqsi/6.1/ODBC64/V5.2/lib:/usr/opt/mqsi/6.1/xml4c/lib64:/usr/opt/mqsi/6.1/xlxpc/lib64:/usr/opt/mqsi/6.1/lib:/usr/opt/mqsi/6.1/bin:/usr/opt/mqsi/6.1/lib:/usr/lib:/u01/oracle/product/10.2/lib32:/u01/oracle/product/10.2/lib:/usr/lib:/lib:/usr/opt/mqsi/6.1/jre15/ppc64/bin:/usr/opt/mqsi/6.1/jre15/ppc64/bin/classic:/usr/mqm/java/lib64:/usr/mqm/lib64:/usr/opt/mqsi/6.1/ODBC64/V5.2/lib:/usr/opt/mqsi/6.1/xml4c/lib64:/usr/opt/mqsi/6.1/xlxpc/lib64:/usr/opt/mqsi/6.1/lib:/usr/opt/mqsi/6.1/bin:/usr/java14/lib:/usr/java14/jre/lib:/usr/java14/jre/bin:/usr/java14/jre/bin/classic:/usr/lib:/var/lib:/usr/opt/mqsi/6.1/merant/lib:/usr/opt/mqsi/6.1/lib:/opt/IBM/db2/V9.1/lib64:/home/db2wbstg/sqllib/lib64

++++++++++++++++++++++
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Mon Apr 14, 2008 1:00 pm    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
Did you ensure you're working with a supported version of Oracle 10g?

Did you adjust the mqsi service user profile (the user that is running mqsistart) to include the Oracle profile as well as the mqsiprofile?

Did you configure both the odbc and odbc64 ini files correctly?
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
vallu
PostPosted: Mon Apr 14, 2008 2:03 pm    Post subject: Reply with quote

Apprentice

Joined: 29 Jun 2002
Posts: 31
10.2.0.1.0 is the client version and it is supported.

It includes both mqsiprofile and oracle profile.

Below the ini file that is being referenced by both ODBCINI and ODBCINI64
+++++++++
[ODBC Data Sources]
MBB01STG=IBM DB2 version 9 ODBC Driver
TESTDSN=DataDirect 5.0 Oracle
PIMDEVODSDSN=DataDirect 5.0 Oracle

###########################################
###### Individual data source stanzas #####
###########################################

# DB2 version 9 stanza
[MBB01STG]
Driver=/usr/opt/mqsi/6.1/lib/libdb2Wrapper64.so
Description=DB2V9DB DB2 ODBC Database
Database=MBB01STG

# Oracle stanza
[TESTDSN]
Driver=/usr/opt/mqsi/6.1/merant/lib/UKor822.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
OptimizePrepare=1
ServerName=dwtest
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1

[PIMDEVODSDSN]
Driver=/usr/opt/mqsi/6.1/merant/lib/UKor822.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
OptimizePrepare=1
ServerName=dwtest
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1


##########################################
###### Mandatory information stanza ######
##########################################

[ODBC]
Trace=0 # To turn on ODBC trace set = 1
TraceFile=/usr/opt/mqsi/6.1/odbctrace64.out
TraceDll=/usr/opt/mqsi/6.1/merant/lib/odbctrac.so
InstallDir=/usr/opt/mqsi/6.1/merant/
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8
++++++++++++++++++
Back to top
View user's profile Send private message
AJStar
PostPosted: Mon Apr 14, 2008 9:26 pm    Post subject: Reply with quote

Acolyte

Joined: 27 Jun 2007
Posts: 64
Have you checked if your "ODBCINI" environment variable points to the correct path of your ODBC64.INI file where the driver details of your DSN reside??
_________________
Regards
AJ
Back to top
View user's profile Send private message
vallu
PostPosted: Tue Apr 15, 2008 11:12 am    Post subject: Reply with quote

Apprentice

Joined: 29 Jun 2002
Posts: 31
Right. The ODBCINI variable is pointing to the right ini file.

[MBB01STG]
Driver=/usr/opt/mqsi/6.1/lib/libdb2Wrapper64.so
Description=DB2V9DB DB2 ODBC Database
Database=MBB01STG

Above is the broker database and it is being referred correctly. The other DSN is giving an issue and it is Oracle DB.
Back to top
View user's profile Send private message
vallu
PostPosted: Tue Apr 15, 2008 3:35 pm    Post subject: Reply with quote

Apprentice

Joined: 29 Jun 2002
Posts: 31
Solved.

[ODBC]
Trace=0 # To turn on ODBC trace set = 1
TraceFile=/usr/opt/mqsi/6.1/odbctrace64.out
TraceDll=/usr/opt/mqsi/6.1/merant/lib/odbctrac.so
InstallDir=/usr/opt/mqsi/6.1/merant/
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8


Remove the above section from ini file
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » [DataDirect][ODBC lib] Specified driver could not be loaded
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.