JDBC and SQL Server 2000 Part II Question

[Nelson Nadal]

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]

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 ]

[Peter den Haan]

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]

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]

Thanks Lasse Koskela and Peter den Haan for replying, I appreciate you, have a good day!!!

[Arpit Aggarwal]

I dont think it will cause any problem . If you are closing connection in finally block

[Pushkar Choudhary]

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.