| Author |
Message
|
| shalabh1976 |
 Posted: Thu Sep 12, 2013 11:44 pm Post subject: DB2 9.5 Connect error from WMB 8 using ODBC |
 |
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
Returning to WMB after a long time.
OS : Win 7 Pro
WMB: V8.0
DB2: Enterprise Server V9.5
ODBC test connect works if I use odbcad32 in C:\Windows\SysWOW64
IBM DB2 ODBC driver does not exist/cannot be seen in default ODBC screen(Start->Administrative Tools->ODBC).
Now I setup a test message flow to access my TEST DB2 database using ODBC via compute node.
I get the following error :
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
mqsisetdbparms has also been run.
I think there is a problem/mismatch between the 64 bit OS and the 32 bit driver. Any known workarounds ?
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Thu Sep 12, 2013 11:59 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
The first part of your problem is here
http://support.microsoft.com/kb/942976
does 'mqsicvp' work when run against the ODBC connection?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Simbu |
| Posted: Fri Sep 13, 2013 12:01 am Post subject: |
|
|
Master
Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India
|
|
| Back to top |
|
|
| shalabh1976 |
| Posted: Fri Sep 13, 2013 12:29 am Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
Output of mqsicvp MB8BROKER -n TEST1
BIP2393E: Database error: ODBC return code '-1' from data source ''TEST1'' using ODBC driver manager ''odbc32.dll''.
The broker received an error when processing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database about this error.
Use the following messages to determine the cause of the error. Typical problems are an incorrect data source, or table names. Correct either the database or the broker configuration.
BIP2322E: Database error: SQL State ''IM014''; Native Error Code '0'; Error Text ''[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application''.
The error has the following diagnostic information: SQL State ''IM014'' SQL Native Error Code '0' SQL Error Text ''[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.
BIP8040E: Unable to connect to the database.
The database cannot be accessed with the specified user Id and password pair.
- Check that the database is running.
- Check that the database has an adequate number of database connections available for use.
- On Windows, check that an ODBC connection has been created.
- On systems that use $ODBCINI, check that the file pointed to by $ODBCINI has been correctly updated.
- On z/OS check the BIPDSNAO member of the component's dataset, and check the DB2 64bit ODBC driver (DSNAO64C) is in the STEPLIB.
- Use mqsisetdbparms to set the password to the correct value and try again.
From odbcad32 console I note the DB2 driver as DB2CLI.dll, I also ran mqsisetdbparms again as C:\Program Files\IBM\MQSI\8.0.0.1>mqsisetdbparms MB8BROKER -n odbc::TEST1 -u db2admin -p db2admin
Restarted the broker as well.
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Sep 13, 2013 3:18 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| shalabh1976 |
| Posted: Fri Sep 13, 2013 3:33 am Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
Downloaded DB2 driver from IBM site (v9.5fp10_ntx64_odbc_cli). Installed the same using db2oreg1. Now driver is seen when I go to ODBC in Administrative tools. However when I try to do a test connect I get the error - ---------------------------
DB2 Message
---------------------------
SQL1531N The database alias "TEST1" could not be found in the db2dsdriver.cfg configuration file.
How do I add this ? Manually or through another utility ?
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Sep 13, 2013 3:47 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| shalabh1976 wrote: |
Downloaded DB2 driver from IBM site (v9.5fp10_ntx64_odbc_cli). Installed the same using db2oreg1. Now driver is seen when I go to ODBC in Administrative tools. However when I try to do a test connect I get the error - ---------------------------
DB2 Message
---------------------------
SQL1531N The database alias "TEST1" could not be found in the db2dsdriver.cfg configuration file.
How do I add this ? Manually or through another utility ? |
Ask this guy -> he's "certified" and should know this :
shalabh1976
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Sep 13, 2013 3:49 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
|
| Back to top |
|
|
| shalabh1976 |
| Posted: Mon Sep 16, 2013 2:24 am Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
Reinstalled DB2...........problem resolved.
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
|
|
|
