| Author |
Message
|
| naio |
 Posted: Wed Jul 24, 2013 6:37 am Post subject: SQL SERVER 2008 ODBC Connection Set Up |
 |
|
Voyager
Joined: 08 Nov 2012
Posts: 82
|
Hello,
(Linux Environment)
I have been trying to configure the Broker to communicate with a MS SLQ SERVER 2008 Database.
I am actually giving a try to the brand new IBM Integration Bus, but as far as I have read this configuration should be the same (I have access
to a 7.0 Broker environment that is working and connecting to several Databases, such as, Oracle, DB2 and SQL SERVER.).
As far as I known, SLQ SERVER 2008 is supported by the DataDirect ODBC drivers, that´s why I do not need to installa the "ODBC Database Extender".
| Quote: |
| WebSphere Message Broker ODBC Database Extender is required when using WebSphere Message Broker to interface with an ODBC data source that is not supported through the DataDirect ODBC drivers. |
I want to know what I am doing wrong, theese were the steps:
1) odbc.ini file was copied to a certain location (/home/mqsiuser), the file has the rigth priviledges:
$ ls -ltr
-rwxrwxrwx. 1 mqsiuser mqbrkrs 3030 Jul 24 11:11 odbc.ini
And also this variable was added to .bash_profile
2) Then, the only thing that was configured in the odbc.ini file was the stanza of the new connectionand other info was removed:
| Code: |
;#######################################
;#### List of data sources stanza ######
;#######################################
[ODBC Data Sources]
SQLSERVERTEST=DataDirect 7.0 ODBC SQL Server Wire Protocol
;###########################################
;###### Individual data source stanzas #####
;###########################################
;# Unix to SQLServer stanza
[SQLSERVERTEST]
Driver=/opt/ibm/mqsi/9.0.0.0/ODBC/V7.0/lib/UKmsss24.so
Description=DataDirect 7.0 ODBC SQL Server Wire Protocol
Address=10.1.7.11,1433
AnsiNPW=Yes
Database=SQLSERVERTEST
QuotedId=No
ColumnSizeAsCharacter=1
LoginTimeout=0
#########################################
;###### Mandatory information stanza ######
;##########################################
[ODBC]
InstallDir=/opt/ibm/mqsi/9.0.0.0/ODBC/V7.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8 |
3) I user the command mqsisetdbparms, but when I test the connection "mqsicvp BK1 -n SQLSERVERTEST" this error is displayed:
| Quote: |
BIP8291W: The IE02_PATH environment variable is not set.
The broker cannot find the IE02_PATH environment variable, which is required by the IBM Integration Bus ODBC Database Extender.
Ensure that the IE02_PATH environment variable is set, and reissue the command.
BIP8296W: The ODBCSYSINI environment variable is not set.
The broker cannot find the ODBCSYSINI environment variable, which is required by the IBM Integration Bus ODBC Database Extender.
Ensure that the ODBCSYSINI environment variable is set, and reissue the command.
BIP8295E: ODBC environment variables have not been set, or are invalid.
The broker cannot verify user data sources because the ODBCINI, ODBCSYSINI, or IE02_PATH environment variables are not set, or because the ODBCINI environment variable is set incorrectly.
Ensure that the ODBCINI environment variable is set, and see earlier warning messages for further details. |
I do not know why it is asking for the IE02_PATH variable, If as far as I know that support pack is not neccesary for SLQ SERVER, and
it is also asking for the ODBCSYSINI variable. In the 7.0 broker environment this variable is not set, anyway I add and odbcsysini.ini file
and the variable in the .bash_profile but the response to the "mqsicvp" is the same.
I would appreciate any Help!
Thanks in Advance!
_________________
"God is in his heaven all's right with the world" |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Wed Jul 24, 2013 6:51 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
And your ODBCINI setting is?
_________________
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: Wed Jul 24, 2013 6:53 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
http://pic.dhe.ibm.com/infocenter/wmbhelp/v9r0m0/index.jsp?topic=%2Fcom.ibm.etools.mft.doc%2Fbn07236_.htm
| Quote: |
On Linux and UNIX systems, the command verifies that the ODBC environment (if specified) is configured correctly.
If the ODBCINI environment variable is set, the mqsicvp command writes warning messages to the syslog in the following circumstances:
If the file to which the ODBCINI environment variable points does not exist, or the broker does not have access to read it or write to it
If ODBCSYSINI is not set
If ODBCSYSINI is set but the directory to which this variable points does not contain a file named odbcinst.ini, or the broker does not have access to read or write to this file
If the IE02_PATH environment variable is not set |
Seems like the ODBC extender is required even if you don't need it.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| naio |
| Posted: Wed Jul 24, 2013 7:03 am Post subject: |
|
|
Voyager
Joined: 08 Nov 2012
Posts: 82
|
smdavies99:
Thanks for your reply, the odbc.ini is what I have written before, I also have in the .bash_profile:
| Quote: |
ODBCINI=$HOME/odbc.ini
export ODBCINI
and
ODBCSYSINI=$HOME/odbcinst.ini
export ODBCSYSINI |
Maybe, there is something missing.
lancelotlinc:
Yes I have read that link, it is strange because the broker V7.0 that I am seen do not have this support pack.
Any way, my next step will be installing this support pack.
I still do not get, why it need the "ODBCSYSINI", I ´ve already set it and I am still getting the message:
| Quote: |
BIP8296W: The ODBCSYSINI environment variable is not set.
The broker cannot find the ODBCSYSINI environment variable, which is required by the IBM Integration Bus ODBC Database Extender. |
But this can be, because the Support Pack is needed.
I will give it a try to the support pack.
Thanks in advance to all!
_________________
"God is in his heaven all's right with the world" |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Jul 24, 2013 8:04 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
does the user under who us running the broker also have access to those settings?
_________________
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 |
|
|
| naio |
| Posted: Wed Jul 24, 2013 9:34 am Post subject: |
|
|
Voyager
Joined: 08 Nov 2012
Posts: 82
|
Yes:
| Quote: |
$ ls -ltr
-rwxrwxrwx. 1 mqsiuser mqbrkrs 1001 Jul 23 17:33 odbcinst.ini
-rwxrwxrwx. 1 mqsiuser mqbrkrs 1831 Jul 24 11:24 odbc.ini |
_________________
"God is in his heaven all's right with the world" |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Jul 24, 2013 9:54 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Is the user under whom the broker is running
1) have the same $HOME as you?
2) Has $ODBCINI properly defined
(Try using a full path rather than $HOME)
_________________
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 |
|
|
| naio |
| Posted: Wed Jul 24, 2013 10:20 am Post subject: |
|
|
Voyager
Joined: 08 Nov 2012
Posts: 82
|
smdavies99:
I will give a try with the full path (I think that yesterday I have tried, but, I already have tried a lot a things.).
I am concerned, since in the 7.0 environment I only see the odbc.ini no Fix Pack and no odbcinst.ini file, and no IE02_PATH variable.
I see in the odbcinst.ini the following content:
| Quote: |
[ODBC]
;# To turn on ODBC trace set Trace=yes
Trace=no
TraceFile=/home/mqsiuser/odbctrace.out
Threading=2 |
odbc.ini and odbcinst.ini are in the same path, and have the same rigths and belong to the same user.
I will try to figure this out.
Any more help will be appreciated!
Thanks in advance.
_________________
"God is in his heaven all's right with the world" |
|
| Back to top |
|
|
| naio |
| Posted: Fri Jul 26, 2013 9:38 am Post subject: |
|
|
Voyager
Joined: 08 Nov 2012
Posts: 82
|
It is working now.
First of all, since V8, WebSphere Message Broker ODBC Database Extender is neccesary.
Then, the configuration fo odbc*.ini files is very important.
Thanks to all!
_________________
"God is in his heaven all's right with the world" |
|
| Back to top |
|
|
| mahesh4eai |
| Posted: Fri Mar 04, 2016 3:29 am Post subject: |
|
|
Novice
Joined: 09 Aug 2014
Posts: 21
|
| Hi Naio...I am facing the same issue..but issue not resolved...Please help me |
|
| Back to top |
|
|
| naio |
| Posted: Fri Mar 04, 2016 5:33 am Post subject: |
|
|
Voyager
Joined: 08 Nov 2012
Posts: 82
|
mahesh4eai,
I cant remember the details right now, but the configuration of ODBC and ODBCINI system variables and files i fundamental.
_________________
"God is in his heaven all's right with the world" |
|
| Back to top |
|
|
|
|
