Audience: Franklin University students enrolled in course COMP281.
Disclaimer: The results and functionality of the following article only apply to audience listed above.
Below are the steps you will need perform to gain access to the virtual desktop (VD) for COMP281. You will be required to access this desktop for all Oracle SQL lab assignments. The software you will use in the VD once you gain access to it is called SQL Developer. SQL Developer will be used to gain access to the Oracle database that resides on the Franklin codd.franklin.edu server. You will NOT be able to download this software to use on your own PC as the port used to gain access to the Oracle database is only available to you through the VD for security reasons. A desktop icon for SQL Developer has been put on the VD for your convenience.
- Enter the URL https://vlab.franklin.edu/ in Google Chrome. You will be presented with the page below:
- Click on the VMware Horizon HTML Access blue button to get to the login page shown below:
- Enter your myFranklin username and password, then click Login button. If you cannot get into the VMware virtual environment using your myFranklin username and password then you will need to submit a support ticket with the helpdesk at http://servicedesk.franklin.edu
- The VMware Horizon main page will be displayed. Click on the COMP 281 button.
- Here is the screen you will see (additional desktop icons may be present then in this image):
- Putty, SQL Developer, WinSCP and web browsers are available to use. Visio 2013 is also preloaded on this VD for your use. Because this software needs a license to operate, you may initially get a message that says the license is not loaded. Just close this window and you should receive a new message stating it has been activated. Give it a couple of minutes and it will be. It will ask you to leave the program and re-enter it. After that you should be good going forward using Visio.
Important Information Regarding Operation of the Virtual Desktop
The VD for this class is non-persistent. What this means is that any files you save anywhere on this desktop will be gone the next time you log in. This also means you will need to re-activate Visio 2013 and re-enter any SQL Developer connection specifics each time you log into the VD. You MUST also remember to go into a browser, enter mail.franklin.edu as the URL and mail yourself a copy of any files you wish to save for future use. Below are some tips for copying files between the VD and your PC.
a. You will NOT be able to perform a direct copy and/or paste between the VD and your PC. But you can use the copy and paste capability within the VD to copy and paste text only from your PC to the VD (not from the VD to your PC). The copy and paste feature is available by clicking on the tab on the left of your VD screen. Once this is open, you will see the following pane:
Click on the middle icon marked with the blue arrow above … this will open the copy and paste panel in the upper right portion of your VD.
Click on the ? for the clipboard help. For example, to copy the contents of a text file, simply open it in notepad, click copy or CTRL C, then go to the VD, click within the clipboard, click CTRL V. Then, go into SQL Developer (or any other application) and click CTRL V again and the text should be copied there.
b. You can also use your email to pass any files between the VD and your PC. For example, you can attach a file to an email and send it to your Franklin email account. You can then open a web browser inside the VD to download the files or content from your email. You can then do this the same way to send files from the VD to your PC once the files are finished.