Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Need to access SQL Server 2000 tables

Author  Topic 

dcintern
Starting Member

1 Post

Posted - 2006-06-03 : 12:14:24
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

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-06-03 : 12:30:06
You can retore the SQL Server 2000 backup into SQL Server 2005.

You can buy the Developer Edition of SQL Server 2005 for about $50 US. It is a completely full featured version of SQL Server 2005, with the exception that it is licensed only for development.

You can also download and use the free version, SQL Server 2005 Express Edition.



CODO ERGO SUM
Go to Top of Page
   

- Advertisement -