| Author |
Message
|
| chenna.hari |
 Posted: Thu Jul 22, 2010 5:43 am Post subject: IM006. 0. [DataDirect][ODBC lib] Driver's SQLSetConnectAttr |
 |
|
Centurion
Joined: 21 Mar 2009
Posts: 103
|
We have MQ and MB 7 in Linux.. and we are trying to connect to SQL Server Database in a compute node in message flow using the Datasource name.
but we are getting error
IM006. 0. [DataDirect][ODBC lib] Driver's SQLSetConnectAttr failed."
Can any help how to resolve this error.
Thanks |
|
| Back to top |
|
 |
| Amitha |
| Posted: Thu Jul 22, 2010 6:19 am Post subject: |
|
|
Voyager
Joined: 20 Nov 2009
Posts: 80
Location: Newyork
|
| It could be for various reasons you may have not set user id password, or haven't specified the correct driver. Please give us more information about the error. |
|
| Back to top |
|
|
| chenna.hari |
| Posted: Fri Jul 23, 2010 1:49 am Post subject: |
|
|
Centurion
Joined: 21 Mar 2009
Posts: 103
|
these are the settings given in ODBC.INI file.
;# Unix to SQLServer stanza
[<datasourcename>]
Driver=<Broker install directory>/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 SQL Server Wire Protocol
Address=<servername>
Database=<databasename>
AnsiNPW=Yes
QuotedId=No
ColumnSizeAsCharacter=1
LoginTimeout=0
and in compute node datasource name is given as <datasourcename>
Please any one help to resolve the error?? |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Jul 23, 2010 2:18 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| chenna.hari wrote: |
these are the settings given in ODBC.INI file.
;# Unix to SQLServer stanza
[<datasourcename>]
Driver=<Broker install directory>/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 SQL Server Wire Protocol
Address=<servername>
Database=<databasename>
AnsiNPW=Yes
QuotedId=No
ColumnSizeAsCharacter=1
LoginTimeout=0
and in compute node datasource name is given as <datasourcename>
Please any one help to resolve the error?? |
Do you actually mean <datasourcename> or did you just replace something like 'MYCOMPANYSECRETDATASOURCE' with <datasourcename>?
if it is the former then I wonder if this is a supported format.
_________________
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 |
|
|
| mqjeff |
| Posted: Fri Jul 23, 2010 2:42 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
And, um.
You do actually have to *REPLACE* "<Broker install directory>" with the real live path to the Broker install directory.
So if that actually still says "<Broker install directory>", then that's the problem. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Jul 23, 2010 3:45 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
And Um (2)
Have you done a mqsisetdbparms to link the DB Odbc definition to the DSN used in the Compute Nodes?
And Um(3)
You need to fill in things like Address & Database names into the stanza as well. How else will the connection find the Windows Server running your Database.
The Broker documentation has all the details of how to setup ODBC connections. There are also many exampled of completed .odbc.ini stanzas in this forum.
There are also exampled of the use of mqsisetdbparm scattered around this forum as well.
_________________
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 |
|
|
| chenna.hari |
| Posted: Fri Jul 23, 2010 3:46 am Post subject: |
|
|
Centurion
Joined: 21 Mar 2009
Posts: 103
|
replaced with company datasource and database and also broker installation directory already ......
can you please help to resolve the error??? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Jul 23, 2010 4:46 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| chenna.hari wrote: |
| can you please help to resolve the error??? |
not without at least the rest of the error message. |
|
| Back to top |
|
|
|
|
