25 November 2014

How to register JDBC driver in WIN-32/WIN-64 for WLP-MSSqlServer

WebLogic Server provides the following XA DLL’s for MS SQL Server (DB Server)
·         sqljdbc.dll: for 32-bit Windows
·         64sqljdbc.dll: for 64-bit Windows
·         X64sqljdbc.dll: for the X64 processors
To install, do the following:
1.    cd to the WL_HOME\wlserver_10.3\server\lib directory
2.    For:
o    32-bit Windows systems, install the sqljdbc.dll file.
o    64-bit Windows systems, copy the 64sqljdbc.dll file, rename as sqljdbc.dll, and then install the sqljdbc.dll file.
o    X64 processors, copy the X64sqljdbc.dll file, rename as sqljdbc.dll, and then install the sqljdbc.dll file.
3.    Along with instjdbc.sql file found under the same directory.
And place the DLL & SQL file under location
For 64-bit
C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn
For 32-bit
C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn
4.    Then execute the instjdbc.sql in your database and restart the DTC server along with SQL server.


to restart the DTC server: go to start --> dcomcnfg --> <open exe>

open: Component Services-->Computers-->My Computer-->Distributed Transaction Coordinator(DTC)-->Local DTC

click Action-->properties-->Security & check all the security settings --> Apply/ok

Br,
Punit

No comments:

Post a comment