This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
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 Java 8 in Action this week in the Java 8 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Issue Connecting to MS SQL Server using WAS Embedded connectjdbc Driver
 
Similar Threads
Issue Connecting to MS SQl Server using WAS Embedded Connect JDBC Driver
jdbc:odbc password definition
Broken Pipe - SQL Server
Datasource Test Connection is successful but the application is not able to connect to the Database
Request cannot be submitted due to wire contention.