| Author |
Message
|
| brokerDev |
 Posted: Fri Jan 26, 2007 9:14 am Post subject: [DataDirect][ODBC lib] Data source name not found.. |
 |
|
Acolyte
Joined: 21 Jun 2006
Posts: 53
|
Hi,
I am getting the following error in a compute node when trying to access a database. The error is:
| Quote: |
| [DataDirect][ODBC lib] Data source name not found and no default driver specified |
We are using WMB v5 on an AIX platform.
I have entered the relevant datasource name against the properties of the node. I have also ran the mqsisetdbparms command to assign the username and password. The tnsnames entry has also been created.
I can connect to the the DB from broker using sqlplus 'user'/'pwd'@schema
I can also tnsping the DB ok.
Any suggestions on what else I can do to troubleshoot?
Thanks |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Fri Jan 26, 2007 9:18 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi brokerDev,
What driver did you use to create the System DSN...?
Regards. |
|
| Back to top |
|
|
| brokerDev |
| Posted: Fri Jan 26, 2007 9:26 am Post subject: |
|
|
Acolyte
Joined: 21 Jun 2006
Posts: 53
|
Hi elvis_gn,
Not sure I understand the question....I got this bit of info from the .odbc.ini file though. Is this what you meant?
Driver=/usr/opt/wmqi/merant/lib/UKor818.so
Regards, |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Fri Jan 26, 2007 9:44 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi brokerDev,
You should go to the control Panel-> Administrative Tasks->ODBC and make a new System DSN entry for your database...you can test the connection using the userId and password from there itself...
THAT is the datasource name that you should use in the Compute node properties...
Regards. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Jan 26, 2007 9:47 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What does the [ODBC] section of the odbc.ini file say?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| brokerDev |
| Posted: Fri Jan 26, 2007 10:06 am Post subject: |
|
|
Acolyte
Joined: 21 Jun 2006
Posts: 53
|
Hi elvis_gn,
I have performed a test connection from my local desktop as you suggested and I got a successful connection using the datasource name that I have used in the compute node properties. I still get the odbc error in broker though.
Hi jefflowrey,
The ODBC section of the .odbc.ini says -
[ODBC Data Sources]
MQSIBKDB=IBM DB2 ODBC Driver
MYDB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 410 Oracle 8 Driver
SYBASEDB=DataDirect 410 Sybase ASE Driver
Regards, |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Jan 26, 2007 10:13 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
There should be an entry in there for your DSN name, that equals the same value as ORACLEDB does.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| brokerDev |
| Posted: Fri Jan 26, 2007 10:59 am Post subject: |
|
|
Acolyte
Joined: 21 Jun 2006
Posts: 53
|
| Have tried that but I'm afraid I'm still getting the error. Besides, we access other databases and we do not have entries for them in the .odbc.ini file. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Jan 26, 2007 11:05 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You have to have an ODBC entry for any access to a database from ESQL, as Broker uses ODBC to access all databases.
You have to follow all the correct procedures as outlined in the manuals for connecting to databases - this includes getting the ODBC entries in .odbc.ini correct.
For an Oracle datasource, you also need to EnableSQLDescribeParam.
And you may need to also source the Oracle db profile into the broker service user's environment.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| brokerDev |
| Posted: Fri Jan 26, 2007 11:46 am Post subject: |
|
|
Acolyte
Joined: 21 Jun 2006
Posts: 53
|
Hi jefflowrey,
Many thanks for you forbearance. You were of course right.
I was looking at .odbc.ini in /var/mqm/odbc and that's why I coudn't see all the other DSNs. I've now edited /home/'broker'/.odbc.ini and we're 'cooking with gas'.
Regards, |
|
| Back to top |
|
|
|
|
