Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes JDBC and SQL Server 2000 Part II Question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC and SQL Server 2000 Part II Question" Watch "JDBC and SQL Server 2000 Part II Question" New topic
Author

JDBC and SQL Server 2000 Part II Question

Nelson Nadal
Ranch Hand

Joined: Jun 06, 2002
Posts: 169
I was asked a question like this...
"Is it possible that I have a web application (jsp/servlets using JDBC) running on Solaris and then the database is in different machine and it is MSSQL Server running on Windows NT? "
I dont know what to say... All I know is it is possible Web application on a machine and Oracle on diff. machine but w/same PLATFORM (Solaris).
Also Web application on a machine and MSSQL/Win Oracle on diff. machine but w/same PLATFORM (Windows NT)
...but w/diff platform Im not sure.

Is it really possible, a web application(on Solaris) accessing a MSSQL database(on different machine and diff. PLATFORM such as Windows)?
Thanks.
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
Sure it's possible. The question is really about whether someone has developed a JDBC driver for the particular database. In the case of MSSQL, open-source drivers don't exist if, I remember correctly, so you need to get a commercial driver. I have only worked with Oracle/DB2/Sybase/MySQL/PostgreSQL myself so I am not that aware of the situation with MSSQL drivers but this is what I've been hearing for the past couple of years.
The fact that the database is running on a different platform doesn't really matter as the processes running on the two are using TCP/IP anyway, which is standard, and the actual database application protocol is implemented by the driver vendor.
[ June 19, 2003: Message edited by: Lasse Koskela ]

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
Peter den Haan
author
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
SQL Server open source drivers do exist. My experiences with this driver weren't very good but that was more than a year ago. As far as free closed-source drivers are concerned, I understand Microsoft has recently(-ish) made a JDBC driver available. My understanding is that it will work for the latest version of SQL Server only, and is not the fastest or most feature-rich on the market; however I have no personal experience with it so check it out for yourself.
- Peter
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
Nice to know, Peter.
Too bad that the development must be quite frustrating... Quoted from the FreeTDS site: FreeTDS was and is developed by observation and experimentation, which is to say, by trial and error.
Nelson Nadal
Ranch Hand

Joined: Jun 06, 2002
Posts: 169
Thanks Lasse Koskela and Peter den Haan for replying, I appreciate you, have a good day!!!
Arpit Aggarwal
Greenhorn

Joined: Feb 11, 2010
Posts: 4
I dont think it will cause any problem . If you are closing connection in finally block
Pushkar Choudhary
Rancher

Joined: May 21, 2006
Posts: 425

Arpit,
Welcome to Javaranch!

We do appreciate your answers on the questions posted here. However, this is a 7 years old thread and I'm quite sure the OP is no longer seeking an answer for it. Please do look how old the thread is before posting. In other words, please Dont Wake The Zombies.
 
 
subject: JDBC and SQL Server 2000 Part II Question
 
Similar Threads
remote JDBC access on dBase files ... on a SCO machine
Question regarding the Database for my webproject.
Can't run adminserver.sh
Check Database is running / not
JSP connection mysql