| Author |
Message
|
| grsharma |
 Posted: Thu Jun 27, 2013 9:55 am Post subject: WMB 7.0.0.5 wiht SolidDb |
 |
|
Newbie
Joined: 27 Jun 2013
Posts: 3
|
Hi All ..
I am trying to configure WMB 7.0 with SolidDB database on a linux 32 bit machine but the two just refuse to talk to each other. I have installed ODBC Database extender and followed all the instructions as found over the internet.
When I run 'solsql' with the DSN name, it works but when I try mqsicvp command with the same DSN name, it fails and I get this error:
BIP2322E: Database error: SQL State ''HY000''; Native Error Code '0'; Error Text ''[DataDirect][ODBC lib] Unicode converter truncated character''.
The error has the following diagnostic information: SQL State ''HY000'' SQL Native Error Code '0' SQL Error Text ''[DataDirect][ODBC lib] Unicode converter truncated character''
Now, both are 32 bit, and I looked and tried everywhere for this information but not able to configure ... appreciated any help / pointers regarding the same. |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Thu Jun 27, 2013 11:01 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
What is the full path of your solidDB Client library?
Does your soliddb odbcini stanza look like this?
| Code: |
;# SolidDB Stanza
[SOLID_DB]
Driver=/opt/solidDB/bin/soca5x6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB
|
What is the value of the environment variable SOLIDDIR ? Is this value visible from the standpoint of the MQBRKRS service Id? ie. sudo to MQBRKRS and query the value.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| grsharma |
| Posted: Thu Jun 27, 2013 5:37 pm Post subject: |
|
|
Newbie
Joined: 27 Jun 2013
Posts: 3
|
Here is how my solidDB looks like
| Quote: |
[ESBDB]
Driver=/opt/solidDB/soliddb-6.5/bin/socl2x65.so
Description=IBM Solid DB ODBC database
Database=ESBDB |
@lancelotline : the 'so' (soca5x6465.so) you have mentioned does not exist in /bin. The IBM documentation also tells to set socl2x65.so in driver path ( linux 32 on x86 ).
$SOLIDDIR = /var/mqsi/odbc ( where the solid.ini file is placed ) and I am running from 'root'.
could it be something with driver type ? I am able to find much documentation on how this works.
|
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Jun 27, 2013 9:00 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| grsharma wrote: |
$SOLIDDIR = /var/mqsi/odbc ( where the solid.ini file is placed ) and I am running from 'root'.
|
[/quote]
Don't run broker under the root id. There are many posts here explaining why this is really NOT a good idea.
Did you do as my esteemed colleague has suggested?
Is the SOLIDIR environment set and visible to the user under which broker is running?
_________________
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 |
|
|
| lancelotlinc |
| Posted: Fri Jun 28, 2013 3:23 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Agree with smdavies. Looks like you have not followed the installation instructions step-by-step for either product.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| grsharma |
| Posted: Thu Jul 11, 2013 12:27 am Post subject: |
|
|
Newbie
Joined: 27 Jun 2013
Posts: 3
|
Hi .. thanks for your support. I did follow the manual exactly how it said ( and that was the mistake  ). It seems that soliddb Unicode driver does not work when connecting from WMB. Therefore updated the driver ( to ASCII) for soliddb and it worked. Correct driver is : sacl2x65.so.
I am pasting my configuration for everyone's benefit:
odbc.ini
---------
[ODBC Data Sources]
ESBDB=IBM SolidDB Datasource
[SOLIDDB]
Driver=/opt/solidDB/soliddb-6.5/bin/sacl2x65.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB
[ODBC]
InstallDir=/opt/ibm/mqsi/7.0/ODBC/V6.0
UseCursorLib=0
IANAAppCodePage=4
odbcinst.ini
-----------------
[ODBC]
Trace=no
TraceFile = /tmp/sql.log
Threading=2
solid.ini
---------
[Data Sources]
SOLIDDB=tcp 127.0.0.1 2315 |
|
| Back to top |
|
|
|
|
