Issue Connecting to MS SQL Server using WAS Embedded Connect JDBCDriver Through Driver Manager - Websphere

This is a discussion on Issue Connecting to MS SQL Server using WAS Embedded Connect JDBCDriver Through Driver Manager - Websphere ; Hi, We are trying to establish Database (DB Server -> MS SQL Server 2000) connections from our application which runs on WAS 6.0.2.17 I now use WAS Embedded ConnectJDBC driver. Driver name i use: com.ibm.websphere.jdbc.sqlserver.SQlServerDriver Connection URL: jdbc:ibm:sqlserver://servername ort;SelectMethod=cursor;User=userid;Password=pwd;D atabaseName=dbname; ...

+ Reply to Thread
Results 1 to 4 of 4

Thread: Issue Connecting to MS SQL Server using WAS Embedded Connect JDBCDriver Through Driver Manager

  1. Issue Connecting to MS SQL Server using WAS Embedded Connect JDBCDriver Through Driver Manager

    Hi,

    We are trying to establish Database (DB Server -> MS SQL Server 2000) connections from our application which runs on WAS 6.0.2.17

    I now use WAS Embedded ConnectJDBC driver.

    Driver name i use: com.ibm.websphere.jdbc.sqlserver.SQlServerDriver

    Connection URL: jdbc:ibm:sqlserver://servernameort;SelectMethod=cursor;User=userid;Password=pwd;D atabaseName=dbname;

    We use both Datasource and Driver manager for connection, all the Datasources when tested work fine but when we connect using Driver manager through the application it throws the following error:

    java.sql.SQLException: [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications.

    Also, when i Test the Driver Manager Connection using the Wizard (Database Explorer) in RAD, all connections through the driver manager work fine.

    I can see that this is a known issue, but am unable to find a solution to the same.

    Any pointers would be of great help.





    Thanks

    Rajesh


  2. Re: Issue Connecting to MS SQL Server using WAS Embedded ConnectJDBC Driver Through Driver Manager

    rajesh_kumar05@infosys.com wrote:
    > Hi,
    >
    > We are trying to establish Database (DB Server -> MS SQL Server 2000) connections from our application which runs on WAS 6.0.2.17
    >
    > I now use WAS Embedded ConnectJDBC driver.
    >
    > Driver name i use: com.ibm.websphere.jdbc.sqlserver.SQlServerDriver
    >
    > Connection URL: jdbc:ibm:sqlserver://servernameort;SelectMethod=cursor;User=userid;Password=pwd;D atabaseName=dbname;
    >
    > We use both Datasource and Driver manager for connection, all the Datasources when tested work fine but when we connect using Driver manager through the application it throws the following error:
    >
    > java.sql.SQLException: [IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications.
    >
    > Also, when i Test the Driver Manager Connection using the Wizard (Database Explorer) in RAD, all connections through the driver manager work fine.
    >
    > I can see that this is a known issue, but am unable to find a solution to the same.
    >
    > Any pointers would be of great help.
    >


    Why are you using driver manager? You really shouldn't be, not in WAS 6.

  3. Re: Issue Connecting to MS SQL Server using WAS Embedded ConnectJDBC Driver Through Driver Manager

    Hi

    Is it Recommended not to use DRiver Manager with WAS 6?..if so, could you please provide pointers to the same..

    Also, the same Driver manager conenctions were working fine while we used Microsoft JDBC Driver for SQL Server.

    Please let me know if thers a solution which would let me use driver manager with WAS 6 using WAS Embedded ConnectJDBC driver..

  4. Re: Issue Connecting to MS SQL Server using WAS Embedded ConnectJDBC Driver Through Driver Manager

    rajesh_kumar05@infosys.com wrote:
    > Hi
    >
    > Is it Recommended not to use DRiver Manager with WAS 6?..if so, could you please provide pointers to the same..


    >
    > Also, the same Driver manager conenctions were working fine while we used Microsoft JDBC Driver for SQL Server.
    >
    > Please let me know if thers a solution which would let me use driver manager with WAS 6 using WAS Embedded ConnectJDBC driver..


    It's been deprecated since WAS 4 ....

    Use WAS connection pooling.

+ Reply to Thread