Macromedia Dreamweaver UltraDev- Connecting to a server database from a Macintosh: Installing the RmiJdbc server component in Windows NT Server

Home > Products > UltraDev > Support > Installation and Configuration

Installing the RmiJdbc server component in Windows NT Server

You must install the RmiJdbc server component on the server hosting your Access database to create a connection from the Macintosh to the Access database. This section describes how to install the RmiJdbc server component in Windows NT Server.

Installing the RmiJdbc server component consists in setting up the server component on NT Server, then starting RmiJdbc.

To set up the RmiJdbc server component in Windows NT Server:

1	Create a folder such as `c:\RmiJdbc` \ and copy the RmiJdbc.jar file from the CD to the new folder.
	The RmiJdbc.jar file is located in the following folder on the CD:
	Third Party Software\RmiJdbc\
2	On the NT desktop, right-click the My Computer icon, select Properties from the pop-up menu, and click the Environment tab.
	The Environment tab appears:
3	In the System Variables list, select the `CLASSPATH` variable if one exists, or select any other variable, if the `CLASSPATH` variable doesn't exist.
	The selected variable's name and value appear in the Variable and Value text boxes at the bottom of the dialog box.
4	In the Variable text box, make sure `CLASSPATH` appears. If you selected another variable, delete its name and enter `CLASSPATH.`
	Note: The initial variable is unaffected and continues to be listed in System Variables.
5	In the Value text box, enter the path to the RmiJdbc.jar file you copied in step 1. Example:
	c:\RmiJdbc\RmiJdbc.jar.
6	Click the Set button to add this variable to the System Variables list.
7	Next, tell the server where to find the Java Development Kit. In the System Variables list, select the `Path` variable if one exists, or select any other variable, if the `Path` variable doesn't exist.
	The selected variable's name and value appear in the Variable and Value text boxes at the bottom of the dialog box.
8	In the Variable text box, make sure `Path` appears. If you selected another variable, delete its name and enter `Path.`
	Note: The initial variable is unaffected and continues to be listed in System Variables.
9	In the Value text box, enter the path to the Java Development Kit folder on your system (jdk1.1.8\bin). If your server already has a server variable, append `jdk1.1.8\bin` to it. If you installed the Java Development Kit in the root folder, append `c:\jdk1.1.8\bin` . Example:
	D:\Oracle\Ora81\bin;d:\Oracle\Ora81\jdbc\lib;c:\jdk1.1.8\bin
10	Click the Set button to add this variable to the System Variables list.
11	Click OK to close the System Properties dialog box.
12	Restart the computer so the new settings can take effect.

To start RmiJdbc:

1	Open an MS-DOS command prompt by selecting Start Menu > Programs > Command Prompt.
2	At the `c:\` prompt, type the following line:
	java RmiJdbc.RJJdbcServer sun.jdbc.odbc.JdbcOdbcDriver
3	Press Enter.
	Your window should look like this:

4	Keep the Command Prompt window open (closing it shuts down the RmiJdbc server).
	You might want to create a batch file to open the window every time Windows NT is rebooted.

A connection can now be created between the Access database on the server and any Macintosh or Windows system that has the RmiJdbc driver.