Need to access SQL Server 2000 tables

[dcintern]

Hello,

I am trying to write a java program that will connect to a SQL Server DB, run some queries, pull some data and try to find some trends in the data.

The problem is that I have a copy of the Database, but I don't have SQL Server. I have been given a backup copy of the database though (SQL Server 2000). I know that in addition to the JDBC driver for SQL Server 2000 I will need something else to be able to access the DB. They have stopped selling SQL Server 2000, also the software tends to be a little expensive.

Is there anything else that I can use that will allow me the functionality og being able to run queries and pull data from the DB using JDBC? Will installing MSDE allow me to do that? Or is there someother software that will allow me to do that? Or do I have no other option excelt installing SQL Server 2000?

Any help is greatly appreciated.

Thanks

 

[gmmastros]

MSDE has a 2 gigabyte limit. If your database is smaller than that, you could install MSDE and attach the database. To download MSDE:

http://www.microsoft.com/downloads/...d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en

MSDE does not include any GUI interface tools. Instead, you could download SQL Server Express 2005. You can attach a SQL 2000 database to it. This does include GUI tools (SQL Server Management Studio Express) to attach the database.

You can download it here:

http://msdn.microsoft.com/vstudio/express/sql/download/

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom