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
381 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 10

Accepted Solution

by:
Hegemon earned 250 total points
ID: 33600306
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
ID: 33603742
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
ID: 33818947
still working on this
0
 

Author Closing Comment

by:1030071002
ID: 33968278
yes
0

Featured Post

Don't Cry: How Liquid Web is Ensuring Security

WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In order for businesses to be compliant with certain information security laws in some countries, you need to be able to prove that a user (which user it was becomes important to the business to take action against the user after an event has occurr…
Are you sitting there reading this and wondering how to get started with Linux? It almost seems like picking the right Linux distribution is about like picking the right college or buying a new car if you read some of the article out there. Relax… l…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

688 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