JDBC for SQL Server for WebSphere MQ Explorer

One, the IBM WebSphere MQ7.0 JDBC Support database has:

• DB2
• Informix
• Informix_with_date_format
• Microsoft_sql_server
• Oracle
• Sybase_jconnect6_05

In this paper, we use the JDBC for server R2 as an example to build JDBC in two ways, as follows:

II. JDBC for SQL Server Building

1. Open MQ Resource Manager, WebSphere MQ Explorer

2. Right click on "Configurable Service" and select "New"-"configurable service"

3. Enter the JDBC name, SQL Server, select the type: jdbcproviders, select the template as: Microsoft_sql_server

4. Modify the values corresponding to the parameters as follows:

5, set the security ID: Mysqlserversi, and bind user name password-u cqmstc-p CQMSTC

Open the MB command Console (refer to http://www.cnblogs.com/hhl-kf/archive/2012/09/25/2694052.html)

Mqsisetdbparms mb7broker-n jdbc::mysqlserversi-u cqmstc-p CQMSTC

6. Hook the security ID to the configuration service

Mqsichangeproperties mb7broker-c jdbcproviders-o sqlserver-n securityidentity-v MySqlServerSI

7. Restart agent, execution Group: mqsireload mb7broker-e Default

8. Delete Configuration Service
Mqsideleteconfigurableservice mb7broker-c jdbcproviders-o SQL Server

9. Command View Configuration service
Mqsireportproperties Mb7broker-o sqlserver-c Jdbcproviders-r

10, the Interface view Configuration service, you can select the Configuration service, right-click "Properties" to edit the changes

Note: Connection string "Jdbc:sqlserver://[servername]:[portnumber];D Atabasename=[databasename];user=[user];p Assword=[password ] "cannot be modified, it will be reported as" user name "" Login Failed ", because the connection string modified, the user is not recognized

Reference: http://www.cnblogs.com/hhl-kf/p/MQ_oracle_jdbc.html

JDBC for SQL Server for WebSphere MQ Explorer