Set Up a Shared Database

Set Up a Shared Database

1. Set up your shared drive on the server via a drive letter (let's say T:\Cube-IQ) - it does need to be the same for everyone otherwise the database locking fails. Please make sure your users can read/write/delete in that folder and sub-folders.

2. Install the software on your client PC(s) if you have not already done so.

3. Before running the client, copy the folders from c:\ProgramData\Cube-IQ5 (there are 3 subfolders called CFG, DATA and DOCS) into your T:\Cube-IQ folder.

(3a. if you are using a PC that has/had Cube-IQ installed, rename (or even delete) the Cube-IQ5 folder in ProgramData after the data copy. This is to make sure that step 4 will work.).

4. Run Cube-IQ -

It will ask where to find the config file. This would be:

Then is will ask for the data folder. This would be:

It will remember those settings for next time.

For the remaining Cube-IQ installations that need the same shared database, simply repeat steps 2, 3, 4 (except step 3 you can simply delete those folders/files from the client PC if they're already on your server - the key is to make sure the client software cannot find them so it has to ask you where they are).

    • Related Articles

    • How to setup a Product Set

      Cube-IQ can have Products comprised as a Set A Product Id comprised of other Products is called a Set. A Set has a Product Id like a regular Product; however, it is comprised of  multiple Products, each with a Quantity of 1 or more. Here is an ...
    • How to Change the Units of Your Database in Cube-IQ

      Background Cube-IQ allows you to change the units of your database without disrupting your loads, products and containers. All dimensions will be automatically converted to your preferred units. How to change your database units Select the Options ...
    • Cube-IQ: Loading by Set

      If you have a requirement to load a group of articles or items which must be kept in exact proportional quantities, you can use Cube-IQ's 'treat groups as sets' feature. You will note that multiple sets can be defined in this way, and Cube-IQ will ...
    • How to set Product Max supported weight

      Products can be limited by the weight of how much other Products are stacked on top of it Here is a Sample Load of 4 Product Ids. The blue Products can only support other Products to a Max. limit of 100 lbs. in this sample. The weights of the yellow ...
    • How to set up Product Configurations

      Product Configurations can be single Unit Configs and/or many Unit Configs A Product can have its unit(s) packed together in different Configurations. Use Configurations to allow a Product Id to have many Configs instead of having different unique ...