This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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]
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: SQL Server and websphere!
It's not a secret anymore!