Skip to content

General

How to use SQL Connect?

SQL Connect Screen

Once you login successfully to SQL Connect, you will see a screen like this showing SQL Account/ SQL Payroll. You can interact with this display just as you would in your normal desktop. Your mouse and keyboard will function as if they were connected directly to the remote machine.

SQL Connect Screen


SQL Connect Menu

To facilitate your works in SQL Connect, we provide a menu containing variety of functions. In order to access the menu, click on the button (circled in red).

SQL Connect Menu 1

After clicking on the button, the menu will be open and you will see the screen below.

SQL Connect Menu 2

With the menu, you can:

  • Disconnect / Logout from SQL Connect
  • Copying / Pasting Text
  • Uploading / Downloading files
  • Zooming In and Out (Scale Display)
  • Changing Input Method

Logout

When you want to quit SQL Connect, kindly use this method. Another way to close completely is by closing the SQL Account/ SQL Payroll application. Click below button available in the menu:

Logout 1

After click the above button, click "Sign out" on the following screen:

Logout 2

This method will sign you out from SQL Connect session properly.


Copy / Paste

You can find a clipboard in the menu as shown below:

Clipboard

Text cut / copied will be shown here. This is for users who have their clipboard not functioning well. Normally, you can copy/paste text directly.

For Google Chrome / Chromium Edge users, make sure clipboard permission is allowed. It definitely save you a lot of time.

Clipboard Google Chrome

Clipboard Chromium Edge

Clipboard Permission

For Mozilla Firefox users who can't get their clipboard working, you may refer to the troubleshooting steps available below:

Troubleshooting: Firefox Clipboard Issue


File Transfer (Upload / Download)

User can transfer files between SQL Connect and their local PC with Shared Drive. It can be accessed by clicking "Shared Drive" in the menu.

Sql Drive 1

Upload

Files can be transferred to SQL Connect by dragging and dropping the files into your browser window, or by clicking at the "Upload Files" button.

Upload 1

The state of all file uploads can be observed in the notification dialog at the bottom right once an upload begins, and can be cleared once completed by clicking the "Clear" button. Downloads are tracked through your browser's own download notification system.

Upload 2

Files uploaded can be accessed via "SQL Drive on SQL Connect"

Upload 3

Download

Files can be downloaded by double click on the file you wish to download in the Shared Drive interface.

If you wish to download file from SQL Connect to your local (and the file is not exist in Shared Drive), you can save it in the "Download" folder in "SQL Drive on SQL Connect". It will then trigger a file download action.

Download 1


Zoom In / Zoom Out (Scaling Display)

By default, SQL Connect will adjust perfectly according to your pc screen resolution. However, if you wish to change the zoom level, you can change it in the menu.

Scaling Display


Changing Input Method

When using SQL Connect in phone/tablet, users may change the input method from "None" to "Text Input". With this, users is able to use virtual keyboard.

Input Method 1 Input Method 2


Backup / Restore Database

For database backup, you can backup it as usual. (In public cloud, we protect users' data by performing backup twice a day). If you wish to download a database backup to you local PC, you may follow the steps in Download section.

For database restore, the process is different for public and private cloud. For public cloud, you can't do the restoration from the web browser. We have purposely lock it to ensure the safety of users' data. You may need to contact our support with your database backup, and your database will be restored in no time.

For private cloud, user can restore database directly in their server. You can perform restoration just like how you do it in the local.


Copy Image into Rich Text Editor

  • Firstly, upload the image file to SQL Connect (via SQL Drive)
  • In SQL Account / SQL Payroll, go to View > File Explorer
  • Navigate to This PC > SQL Drive on SQL Connect > double click to open your image file
  • Select All (or press Ctrl + A), and then copy it.
  • Go to the rich text editor, paste the image you just copy.

Copy Image Rich 1 Copy Image Rich 2 Copy Image Rich 3 Copy Image Rich 4


Delete Files in SQL Drive

Delete Files 1 Delete Files 2


Printing Half Page

  • Add paper size.

Half Page 1

  • Add another printer as norm for Half Page.

Half Page 2 Half Page 3 Half Page 4

  • Set default paper size.

Half Page 5

  • Once you have done with the above settings, login into your SQL Connect session and test print with the following steps:

Half Page 6 Half Page 7


Saving PDF

If you want to download PDF file, save it to the "Download" folder in the "SQL Drive on SQL Connect"

Save Pdf 1

It will then trigger the browser print window:

Save Pdf 2

Usually, you will select your local printer here. WAIT!!!! You want to save a pdf, so change it to "Save as PDF".

Save Pdf 3


Signout (Private Cloud only)

The is exclusive for private cloud users only. In private cloud, the user has control over the server. Thus, the admin has the right to signout connections.

Signout Connection


SQL Connect Printing

In SQL Connect, we have two groups of users (Public cloud users & private cloud users). As a private cloud users, you can print directly to your local printer as long as the printer is accessible from your server. In public, the only option you have is to use the "SQL Connect Printer" and then forward to your local printer.

Print 1

By using "SQL Connect Printer", you will then able to access the browser print dialog which has the right to utilize your local printer. From there, you can select the printer you want, size you like and so on and finally click print. Below is an example of chrome print dialog:

Print 2


Alternative to SQL Connect Printer

Print Alt 1 Print Alt 2 Print Alt 3 Print Alt 4 Print Alt 5


SQL Utilities

To add SQL Utilities, follow the steps below:

  1. Go to File > Run > Configure Program...
  2. Add the utilities software from here: C:\eStream\Utilities
  3. After add successfully, the program should be available at File > Run > ...

Sql Utilities 1 Sql Utilities 2 Sql Utilities 3 Sql Utilities 4

SQL Connect Subscription Checker

To check your subscription, you can open the app by following the steps below:

  1. Go to File > Run
  2. Select SQL Connect Subscription Checker

SQL Connect Subscription Checker 1

If the app is not there, you can add it by following the steps below:

  1. Go to File > Run > Configure Program...
  2. Add the program from here: C:\eStream\Utilities
  3. After add successfully, the program should be available at File > Run > ...

Sql Utilities 1 SQL Connect Subscription Checker 2 Sql Utilities 3 Sql Connect Subscription Checker 3


  1. This is for public cloud users only.
  2. Once requested, you will receive a file link. In the file, you can find all the information required to link local SQL Pos with SQL Account. Example on how the file looks like:

    Link with SQL Pos 1

  3. In SQL Pos, fill in accordingly.

    Link with SQL Pos 2

Back to top