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 ...
    • 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 ...
    • CUBE-IQ V5.X: How to Backup and Restore up a database

      You can create a backup of your Cube-IQ database by clicking on: The System Menu icon in top-left Database Tools Backup Database You will then have a backup of your data.  If you need to migrate this data to a new PC, then click on the System Menu ...