wood burning stoves 2.0*
The moose likes JDBC and the fly likes Issue Connecting to MS SQL Server using WAS Embedded connectjdbc Driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Issue Connecting to MS SQL Server using WAS Embedded connectjdbc Driver" Watch "Issue Connecting to MS SQL Server using WAS Embedded connectjdbc Driver" New topic
Author

Issue Connecting to MS SQL Server using WAS Embedded connectjdbc Driver

Rajesh MadhanGopal
Ranch Hand

Joined: Jan 19, 2006
Posts: 69
Hi,

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

I now use WAS Embedded ConnectJDBC driver.

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

Connection URL: jdbc:ibm:sqlserver://servername ort;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 a known issue, but am unable to find a solution to the same.

Any pointers would be of great help.


Thanks<br />Rajesh
Remko Strating
Ranch Hand

Joined: Dec 28, 2006
Posts: 893
Maybe the following link could be helpful


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


Remko (My website)
SCJP 1.5, SCWCD 1.4, SCDJWS 1.4, SCBCD 1.5, ITIL(Manager), Prince2(Practitioner), Reading/ gaining experience for SCEA,
Rajesh MadhanGopal
Ranch Hand

Joined: Jan 19, 2006
Posts: 69
Hi,

The above given link does not work ...

Can someone help me on this..we are badly stuck bcoz of this issue..
Remko Strating
Ranch Hand

Joined: Dec 28, 2006
Posts: 893
I try again.

Link Again
 
jQuery in Action, 2nd edition
 
subject: Issue Connecting to MS SQL Server using WAS Embedded connectjdbc Driver
 
Similar Threads
Request cannot be submitted due to wire contention.
jdbc:odbc password definition
Issue Connecting to MS SQl Server using WAS Embedded Connect JDBC Driver
Broken Pipe - SQL Server
Datasource Test Connection is successful but the application is not able to connect to the Database