MSSQL Server 2000 Connection????

[rjwelte]

Cannot Connect to the MSSQL Server 2000 Instance using the Microsoft JDBC Driver.

Error: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is either invalid or not running.
Location: MySQL2000

The instance is running, but it appears Oxygen can't see it.

Please help me make a connection. thankyou.

john welte

[sorin_ristache]

Hello,

If you try to access a MS SQL Server 2000 database you have to:

1) Go to Preferences -> Data Sources. In the Data Sources panel click the New button.
2) Enter a unique name for this data source and select Generic JDBC from the driver type combo box.
3) Add the following MSSQL2000 specific files:mssqlserver.jar, msbase.jar and msutil.jar downloaded from the Microsoft website.
4)Select the "com.microsoft.jdbc.sqlserver.SQLServerDriver" Driver class.
Click OK to finish the data source configuration.

To create the connection:
1) Go to Preferences -> Data Sources. In the Connections panel click the New button.
2)Enter a unique name for this connection and select one of the previously configured Generic JDBC data sources from the Data Source combo box.
3)Fill-in the Connection Details using the following URL format:
jdbc:microsoft:sqlserver://<host>:<port1433>;DatabaseName=<database>
Make sure you specify the correct instance name.
Click OK.

Regards,
Sorin