Back

Topic

[KB178]Errors 14006 and 14007: Error Creating Table

Tags: Error, Error ID, Error messages numbers

Audit and diagnostic
14 years ago
By RM
Options
Print
Applies to:

PcVue all versions.
Summary:

This article explains how to deal with error messages 14006 and 14007.
Details:

French PcVue : 14006, %s : Erreur création table %s
English PcVue : 14007, %s : Error creating table %s

The first %s is the PcVue database name and ODBC database name.
The second %s is the name of the table that you are trying to create.

Explanation

This message in the Event Viewer states that creation of a table by PcVue in an ODBC database has failed.

These are the most usual reasons for the message :

  1. You do not have user rights for creating a table in the database.
  2. The specified table name is incorrect for the database.
  3. The selected database is not valid with PcVue.

To obtain more information

One of the reasons why PcVue returns the above message is that PcVue sends SQL requests with invalid syntax.

For more information about communication between ODBC and PcVue, you can activate Log files. The Log files record all SQL requests between ODBC and PcVue for each ODBC database.

How to activate a Log File

To activate a Log file for an ODBC database:

  • In the Start menu, select the Settings.Control Panel.
  • Double-click on ODBC Data sources icon.
  • In User DSN tab, select the ODBC database you wish to trace.
  • Select the Tracing tab. Depending on the ODBC versions, the setup menus for ODBC should change. Here is the Tracing tab menu for ODBC version 3.51:

odbc

The creation of the table is noted in a Log file by the string create table followed by the SQL request sent by PcVue. The reason why PcVue returns Error creating table may be because these SQL requests are not understandable by the ODBC database, so check the SQL requests syntax.

Created on: 19 Nov 2010 Last update: 13 May 2024