Bogdan Ionita wrote:
We have a application which communications via java to a .DBF file
(using Java
and Codebase for Linux). We are working on moving the database over
to MS-SQL
server (relational). What is the preferred method of communicating
with a
MS-SQL database using Java (JDBC, etc)? Can someone point me in the right
direction?
Hi,
you might try http://www.microsoft.com/sql/ . Somewhere on that page is a link to a JDBC driver. They have a win version and a unix version, and it seems to be free. But of course, we are talking about MS, so you should read any "fine print" you find.
Shouldn't need to be two versions, just a jar file, unless they've been silly and included native methods, which will mess with your ability to choose what platform to run your Java code on. However, looking at what they say, it's a Type 4 (pure Java) driver all right, so that's good, and the unix / windows versions are just packaging; The Windows one is in a setup.exe and the unix one is in a tarfile. Damn, one good reason not to use SQLServer shot down in flames You'll have to use one of the others :-> I'm actually quite surprised they did this, and in a good way too. :-) -- Rachel