MSSQL Server 2000 Connection????

<oXygen/> general issues.
rjwelte
Posts: 1
Joined: Sun Jan 07, 2007 1:03 am

MSSQL Server 2000 Connection????

Post by rjwelte » Sun Jan 07, 2007 1:20 am

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
Posts: 4144
Joined: Fri Mar 28, 2003 2:12 pm

Post by sorin_ristache » Mon Jan 08, 2007 4:43 pm

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

Post Reply