Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Issue Connecting to MS SQL Server using WAS Embedded connectjdbc Driver

 
Rajesh MadhanGopal
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Remko Strating
Ranch Hand
Posts: 893
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Maybe the following link could be helpful


[IBM][SQLServer JDBC Driver]This driver is locked for use with embedded applications.
 
Rajesh MadhanGopal
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 893
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I try again.

Link Again
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic