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://servername:port;SelectMethod=cursor;User=userid;Password=pwd;DatabaseName=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

[email]rajesh_kumar05@infosys.com[/email] wrote:[color=blue]
> 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:port;SelectMethod=cursor;User=userid;Password=pwd;DatabaseName=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.
>[/color]

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

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..

[email]rajesh_kumar05@infosys.com[/email] wrote:[color=blue]
> Hi
>
> Is it Recommended not to use DRiver Manager with WAS 6?..if so, could you please provide pointers to the same..[/color]
[color=blue]
>
> 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..[/color]

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

Use WAS connection pooling.