Solved

JSP on Linux I need to access a microsoft sql server 2005 from jsp on linux how do I do that

Posted on 2010-09-03
4
334 Views
Last Modified: 2013-11-15
JSP on Linux I need to access a microsoft sql server 2005 from jsp on linux how do I do that
0
Comment
Question by:1030071002
  • 2
4 Comments
 
LVL 10

Accepted Solution

by:
Hegemon earned 250 total points
Comment Utility
JSP is a presentation level - what you will display.
To access the database you will need a database access tier. Of course you can put all your database access code to JSPs but his design smells.

JSP on lLinux - it does not matter if it is run on Linux or not.

Your code will need to load a MS SQL JDBC driver, establish a JDBC connection to the MySQL server. It is ok that the MS SQL server will be on a different machine under Windows.

I suggest reading  this JDBC tutorial: http://download.oracle.com/javase/tutorial/jdbc/index.html
0
 
LVL 2

Assisted Solution

by:karthi_bv
karthi_bv earned 250 total points
Comment Utility
check below links

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2162&lngWId=2

http://support.microsoft.com/kb/313100

For  Microsoft SQL Server:
Class.forName("com.microsoft.jdbc.SQLServerDriver" );
Connection con=DriverManager.getConnection
("jdbc:host://localhost:8080/sample","sample","sa""sa");
0
 

Author Comment

by:1030071002
Comment Utility
still working on this
0
 

Author Closing Comment

by:1030071002
Comment Utility
yes
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
I am having a difficulty creating a responsive Page for my website. 10 78
Linux Search 3 64
Truecrypt and swap 6 90
Backing Up Ipset 9 64
In my business, I use the LTS (Long Term Support) versions of Linux. My workstations do real work, and so I rarely have the patience to deal with silly problems caused by an upgraded kernel that had experimental software on it to begin with from a r…
1. Introduction As many people are interested in Linux but not as many are interested or knowledgeable (enough) to install Linux on their system, here is a safe way to try out Linux on your existing (Windows) system. The idea is that you insta…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now