MQSeries.net :: View topic - IIB 10.0.0.6 ODBC Licensing

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » IIB 10.0.0.6 ODBC Licensing

IIB 10.0.0.6 ODBC Licensing

« View previous topic :: View next topic »

Author

Message

smdavies99

Posted: Wed Sep 21, 2016 5:13 am Post subject: IIB 10.0.0.6 ODBC Licensing

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Following from this post
http://www.mqseries.net/phpBB2/viewtopic.php?p=405484

I'm getting the same here when trying to access an Oracle DB via ODBC.

This code

Code:

SET OutputRoot.XMLNSC.Data.Company[] = (SELECT * FROM Database.COMPANY WHERE COMPANY.NAME = 'IBM' );

{real company name obfuscated for this post}

Fails with the Licensing error. Yet, this code does work.

Code:

DECLARE cSQL char;
SET cSQL = 'select count(1) from COMPANY';
set Environment.Data.COMPANY[] = PASSTHRU(cSQL);

I installed 10.0.0.0 Developer edition into the default directory and
10.0.0.6 into its default directory.

The Broker was started using the 10.0.0.6 console and the effective version is 10.0.0.6
The oracle client is 11GR2.

Thoughts anyone?
_________________
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.

mqjeff

Posted: Wed Sep 21, 2016 5:30 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Some thoughts:
http://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/an26192_.htm

On Linux and UNIX systems, delete the ODBCINI64 environment variable if it exists; it is not required by IBM Integration Bus Version 10.0.

http://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/bk58060_.htm - in particular all of the steps in "Procedure"
And note that there's a lot of information about how to configure talking to Oracle with many different configurations...

And I'm assuming you've used the DataDirect drivers, rather than the Oracle native drivers.

Thirdly, as a next step, you can take an ODBC trace and see who's complaining about the license.
_________________
chmod -R ugo-wx /

smdavies99

Posted: Wed Sep 21, 2016 5:31 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

From firther investigation it appears that the wildcard select does not work

Code:

select A.ID,A.NAME,A.COUNTRY from Database.COMPANY ....

works

but

Code:

select * from Database.COMPANY ....

Fails.

The SQL is good in Oracle Developer.

Oh well. good job this is a POC.
_________________
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.

smdavies99

Posted: Wed Sep 21, 2016 5:50 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

mqjeff wrote:

Some thoughts:

And I'm assuming you've used the DataDirect drivers, rather than the Oracle native drivers..

Opps. changed now. so the lisensing problem goes away.

It all works. So easy to get the wrong driver when you are doing things in a rush.
Thanks
_________________
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.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » IIB 10.0.0.6 ODBC Licensing

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