aspose file tools
The moose likes Websphere and the fly likes SQL Server and websphere! Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » Websphere
Reply Bookmark "SQL Server and websphere!" Watch "SQL Server and websphere!" New topic
Author

SQL Server and websphere!

Laura Mike
Greenhorn

Joined: Nov 13, 2003
Posts: 17
hello,
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.
Thanx.
Jialin Li
Greenhorn

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
author
Sheriff

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


Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
 
I agree. Here's the link: http://zeroturnaround.com/jrebel
 
subject: SQL Server and websphere!
 
Similar Threads
How to use SQL database for J2EE web logins
General Database Question
Query Optimization
Connecting to SQL Server from NetBeans
Can't connect to remote sql server