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
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
367 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
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Creating a Samba server for a small office. Ubuntu Linux and Samba can breathe new life into a retired PC and save an office money on new hardware/software. Our example server will have two hard disks, one exclusively for storing shared data. …
The purpose of this article is to show how we can create Linux Mint virtual machine using Oracle Virtual Box. To install Linux Mint we have to download the ISO file from its website i.e. http://www.linuxmint.com. Once you open the link you will see …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

839 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