How do I configure the driver from Microsoft for SQL Server 2000?
A. See “Installing and Using the SQL Server 2000 Driver for JDBC from Microsoft” in Programming WebLogic JDBC. Each instance of MS SQL Server must be listening on a different port. So, you can use the port number in the properties that you pass to the getConnection() method or, in case of connection pools, you can specify the port property in the following properties: server=machine Nameport=instancePort To find the port number where each MS SQL Server instance is running, run the server network utility (in the Microsoft SQL Server program group), select the server instance, select TCP/IP, and click the properties button. The full pathnames for the msbase.jar, msutil.jar, and mssqlserver.jar files must be in the in the CLASSPATH for the server startup script (e.g., STARTWEBLOGIC.CMD), not just in your CLASSPATH. Also, it may be necessary to append connection properties to the URL for the connection pool in the administration console, separated by semicolons, rather than using the Prope
