Laplink Everywhere SQL Processing Feature

What is SQL Processing Feature?

The Laplink Everywhere SQL Processing feature is used to access the power and flexibility of forms from a SQL database. This feature can be found after login into Laplink Everywhere via your web browser and locating "Remote Database" on the Laplink Everywhere left toolbar. This feature must be configured in order to work properly.

How will it help me?

SQL Database administrators write menu-driven "applications" using stored procedures that allow remote users to create and track orders or whatever the specific business need is. As an example, for the creation and tracking of orders, it allows remote users to create and track orders from beginning to end as follows:

  • Check inventories
  • Create orders
  • Submit orders
  • Track orders through the enterprise
  • Prepare orders for shipment, and so on

How do I go about setting it up?

A SQL Database with the forms, stored procedures, etc. required to meet your business needs must be created and an ADO connection string then supplied to Laplink Everywhere on the host computer. A demo database is available for download and the tutorial below will assist you in loading this database and configuring the Laplink Everywhere host to access it.

  1. Download SQLProcessing.zip to a folder on your SQL Server that you can access when the download is complete. (download here)
  2. Extract files from SQL Processing.zip to C:\Program Files\Microsoft SQL Server\MSSQL
    • A folder "SQLProcessing" will be created which contains all the database files you will need.
  3. Launch SQL Enterprise Manager

  4. Right click on "Databases"
  5. Click "All Tasks"
  6. Click "Attach Database" this will launch the "Attach Database" window

  7. Click the button with the three dots that is to the left of the verify button
  8. This will launch the "Browse for Existing File" window
  9. Browse to C:\Program Files\Microsoft SQL Server\MSSQL\SQLProcessing\Data
  10. Select FoneFile_Data.mdf and click ok
  11. You will now see a .jdf and .ldf file

  12. Change "Attach as" field to LLESQLProcessing
  13. Click OK
  14. The following box will appear – click OK

  15. The "Attach Database" window will close automatically and you will be returned to SQL Enterprise Manager
  16. Under Databases you will now see LLESQLProcessing

  17. Close SQL Server Enterprise Manager

    We're now going to confirm access to our SQL Server.

  18. Launch SQL Query Analyzer
  19. A Connect to SQL Server window will pop up

  20. The SQL Server field should contain the name of your SQL Server Database
  21. Ensure SQL Server authentication is selected and enter username and password for SA (this is the username you setup when creating your SQL Server Database)
  22. Click Ok
  23. A query window should open and you should be looking at the master database
  24. If no logon errors occurred in #23 above, close the query analyzer

    We're now going to setup Laplink Everywhere to point to our SQL database so go to your workstation that you installed Laplink Everywhere on

  25. Go to the workstation that you installed Laplink Everywhere on
  26. Double click on the Laplink Everywhere icon in the system tray and a Laplink Everywhere control panel will open

  27. Click on Configure and then click on remote database
  28. You will see a Remote Database windows with an "ADO Connection String" field

  29. Place your cursor in the "ADO Connection String" window and type the following:

      Provider=SQLOLEDB;Data Source=machine_name;Database=LLESQLProcessing;User Id=sa;Password=passcode

      *You must replace machine_name with the Computer Name of the SQL Server

      *You must replace passcode with the password for SA that you setup when you installed SQL Server.

  30. Click OK
  31. Close your Laplink Everywhere Control Panel
  32. Launch www.ll2go.com and login as you normally would
  33. Go to the workstation in www.ll2go.com that you configured the remote database access to
  34. Click on remote database
  35. The window on the left of www.ll2go.com will display my.remote database and allow you access to the demo database that we just established.