Showing results 1 to 3 of 3

Thread: Create database IMM

  1. #1
    Join Date
    30.09.2010
    Posts
    14

    Default Create database IMM

    Hello,

    I have a question about IMM.

    Therefore I have create a new database with four tables.
    Witch columns must I created in the tables?

    I use the help file "Industrial Maintenance Manager (IMM).PDF" but in chapter 5.2 it is not defined.

    Thank you in advance,

    Daan

  2. #2

    Default Re: Create database IMM

    Hi Daan,

    Sorry for the late reply...

    Basically the only thing you need to create first, is the SQL database in the SQL server.

    There is no need for you to create any tables, these are automatically created by the zenon runtime, the first time that the IMM screen is opened, using the names defined in the project properties.

    Make sure, that the SQL user that you specify in the ODBC connection string has the appropriate rights (CREATE TABLE, ...) for the first runtime start.

    Click image for larger version

Name:	ScreenShot856.png
Views:	37
Size:	9.3 KB
ID:	650

    When you are using the same names for the tables in the project properties as you created manually, or the user does not have the appropriate user rights, this may be causing the issues.


    In case it is of any help, please find below the create table statements (generated in SQL Server Management Studio) for the tables of the screenshot above, that were automatically created by the runtime.

    IMM_table_create_statements.txt

    Let us know if you need any further help or have any other issues!

    Regards,
    Mark

  3. #3
    Join Date
    30.09.2010
    Posts
    14

    Default Re: Create database IMM

    Hi Mark,

    No problem.
    Thanks, it works now!!

Similar Threads

  1. Database cannot be opened! Error
    By jhines in forum zenon Supervisor
    Replies: 5
    Last Post: 22nd February 2018, 01:14
  2. Database Access
    By whitetaru in forum Drivers
    Replies: 11
    Last Post: 20th September 2011, 22:48
  3. SQL Database and Zenon Editor
    By bmcbrita in forum zenon Supervisor
    Replies: 4
    Last Post: 2nd August 2009, 22:24
  4. SQL Database files
    By bmcbrita in forum zenon Supervisor
    Replies: 7
    Last Post: 17th June 2009, 14:26
  5. Backup database
    By matholton in forum zenon Supervisor
    Replies: 1
    Last Post: 17th October 2008, 13:49

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •