File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Websphere and the fly likes SQL Server and websphere! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "SQL Server and websphere!" Watch "SQL Server and websphere!" New topic

SQL Server and websphere!

Laura Mike

Joined: Nov 13, 2003
Posts: 17
I want to use an existing SQL Server database which is at a remote server.
I am using Jconnect driver for SQL Server 2000.
How can i do that? this is my first try to use a database other than cloudscape. plzgive me some details to do so.and also if there is any online example for this process will be an added help.
need it urgently.
Jialin Li

Joined: Nov 10, 2003
Posts: 4
You can create a jdbc provider, then create a datasource. To do that you must have the jdbc driver. Above all can be done in admin console of was5.
If you want to find an example, you can refer to IBM Redbook WAs 5 admin handbook.
Lasse Koskela

Joined: Jan 23, 2002
Posts: 11962
Our naming policy disallows initials for a last name, so I'll have to ask you to change your display name accordingly.

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
It is sorta covered in the JavaRanch Style Guide.
subject: SQL Server and websphere!
jQuery in Action, 3rd edition