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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

If you use Debian 6 Squeeze and you are tired of looking at the childish graphical GDM login screen that is used by default, here's an easy way to change it. If you've already tried to change it you've probably discovered that none of the old met…
The purpose of this article is to demonstrate how we can upgrade Python from version 2.7.6 to Python 2.7.10 on the Linux Mint operating system. I am using an Oracle Virtual Box where I have installed Linux Mint operating system version 17.2. Once yo…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

730 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