invalid column name 'Name' error

[pintoj]

I'm evaluating the product and just installed it. I'm opening a SQL Server 2000 database and whenever I try to access the details of any table in the database (say the columns) I always get the message:

Invalid column name 'Name'.

This is preventing me from diagramming the database.

However, it isn't stopping me from retrieving the data in the tables.


Help!

[alexa]

Could you please provide us the product's name along with its version and the CREATE TABLE statement of the table?

[pintoj]

I'm not sure which product name you are looking for. Are you asking me which devart product name? If so, I am using (evaluating) dbForge Studio for SQL Server 3.0 Professional Trial version 3.0.185. It doesn't seem to matter which table I point it at, I am getting the error on every table in the DB. Here's an example of one of them:
CREATE TABLE [dbo].[ttiitm001100]
(
[t_item] [char] (16) COLLATE Latin1_General_BIN NOT NULL,
[t_dsca] [char] (30) COLLATE Latin1_General_BIN NOT NULL,
[t_dscb] [char] (8) COLLATE Latin1_General_BIN NOT NULL,
[t_dscc] [char] (12) COLLATE Latin1_General_BIN NOT NULL,
[t_dscd] [char] (8) COLLATE Latin1_General_BIN NOT NULL,
[t_wght] [float] NOT NULL,
[t_seak] [char] (16) COLLATE Latin1_General_BIN NOT NULL,
[t_seab] [char] (16) COLLATE Latin1_General_BIN NOT NULL,
[t_kitm] [binary] (1) NOT NULL,
[t_citg] [char] (6) COLLATE Latin1_General_BIN NOT NULL,
[t_ctyp] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_csel] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_csig] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_cvat] [char] (9) COLLATE Latin1_General_BIN NOT NULL,
[t_txta] [int] NOT NULL,
[t_uset] [char] (6) COLLATE Latin1_General_BIN NOT NULL,
[t_cuni] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_stgu] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_cwar] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_kltc] [binary] (1) NOT NULL,
[t_obpr] [binary] (1) NOT NULL,
[t_kpsl] [binary] (1) NOT NULL,
[t_npsl] [int] NOT NULL,
[t_pics] [binary] (1) NOT NULL,
[t_abcc] [char] (1) COLLATE Latin1_General_BIN NOT NULL,
[t_lcod] [datetime] NOT NULL,
[t_uscu] [float] NOT NULL,
[t_usab] [float] NOT NULL,
[t_slmp] [binary] (1) NOT NULL,
[t_serv] [binary] (1) NOT NULL,
[t_sfst] [float] NOT NULL,
[t_maxs] [float] NOT NULL,
[t_csps] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_cspd] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_cfmd] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_scst] [float] NOT NULL,
[t_stoc] [float] NOT NULL,
[t_blck] [float] NOT NULL,
[t_ordr] [float] NOT NULL,
[t_allo] [float] NOT NULL,
[t_hall] [float] NOT NULL,
[t_quot] [float] NOT NULL,
[t_ltdt] [datetime] NOT NULL,
[t_opol] [binary] (1) NOT NULL,
[t_osys] [binary] (1) NOT NULL,
[t_omth] [binary] (1) NOT NULL,
[t_oqmf] [float] NOT NULL,
[t_mioq] [float] NOT NULL,
[t_maoq] [float] NOT NULL,
[t_umer] [binary] (1) NOT NULL,
[t_fioq] [float] NOT NULL,
[t_ecoq] [float] NOT NULL,
[t_reop] [float] NOT NULL,
[t_oint] [smallint] NOT NULL,
[t_ddfq] [float] NOT NULL,
[t_oltm] [smallint] NOT NULL,
[t_sftm] [smallint] NOT NULL,
[t_fodt] [datetime] NOT NULL,
[t_ocst] [float] NOT NULL,
[t_auso] [binary] (1) NOT NULL,
[t_cpha] [binary] (1) NOT NULL,
[t_oqdr] [binary] (1) NOT NULL,
[t_repi] [binary] (1) NOT NULL,
[t_scdl] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_orip] [binary] (1) NOT NULL,
[t_pcrp] [binary] (1) NOT NULL,
[t_stpm] [binary] (1) NOT NULL,
[t_mrpc] [smallint] NOT NULL,
[t_plmm] [binary] (1) NOT NULL,
[t_mrpo] [binary] (1) NOT NULL,
[t_eitm] [binary] (1) NOT NULL,
[t_bfcp] [binary] (1) NOT NULL,
[t_bfep] [binary] (1) NOT NULL,
[t_bfhr] [binary] (1) NOT NULL,
[t_ndrp] [binary] (1) NOT NULL,
[t_nnts] [smallint] NOT NULL,
[t_qpnt] [float] NOT NULL,
[t_unom] [float] NOT NULL,
[t_runi] [float] NOT NULL,
[t_scpf] [smallint] NOT NULL,
[t_crmp] [binary] (1) NOT NULL,
[t_tmfc] [smallint] NOT NULL,
[t_roun] [binary] (1) NOT NULL,
[t_ncst] [binary] (1) NOT NULL,
[t_llcd] [binary] (1) NOT NULL,
[t_llci] [smallint] NOT NULL,
[t_mrpi] [smallint] NOT NULL,
[t_stmr] [float] NOT NULL,
[t_cuqp] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_cupp] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_cpgp] [char] (6) COLLATE Latin1_General_BIN NOT NULL,
[t_csgp] [char] (6) COLLATE Latin1_General_BIN NOT NULL,
[t_pcgp] [char] (6) COLLATE Latin1_General_BIN NOT NULL,
[t_ccur] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_ltpp] [datetime] NOT NULL,
[t_prip] [float] NOT NULL,
[t_avpr] [float] NOT NULL,
[t_ltpr] [float] NOT NULL,
[t_suno] [char] (6) COLLATE Latin1_General_BIN NOT NULL,
[t_qual] [binary] (1) NOT NULL,
[t_purc] [float] NOT NULL,
[t_txtp] [int] NOT NULL,
[t_cuqs] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_cups] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_cpgs] [char] (6) COLLATE Latin1_General_BIN NOT NULL,
[t_csgs] [char] (6) COLLATE Latin1_General_BIN NOT NULL,
[t_cmgp] [char] (6) COLLATE Latin1_General_BIN NOT NULL,
[t_rbgp] [char] (6) COLLATE Latin1_General_BIN NOT NULL,
[t_pris] [float] NOT NULL,
[t_ltsp] [datetime] NOT NULL,
[t_prir] [float] NOT NULL,
[t_umsp] [real] NOT NULL,
[t_lmsp] [real] NOT NULL,
[t_ccde] [char] (8) COLLATE Latin1_General_BIN NOT NULL,
[t_ctyo] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_txts] [int] NOT NULL,
[t_cpcp] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_copr] [float] NOT NULL,
[t_matc] [float] NOT NULL,
[t_oprc] [float] NOT NULL,
[t_cuid] [smallint] NOT NULL,
[t_actf] [float] NOT NULL,
[t_ltcp] [datetime] NOT NULL,
[t_stva] [binary] (1) NOT NULL,
[t_buyr] [int] NOT NULL,
[t_cplb] [int] NOT NULL,
[t_cppp] [binary] (1) NOT NULL,
[t_ccit] [char] (16) COLLATE Latin1_General_BIN NOT NULL,
[t_ccfu] [binary] (1) NOT NULL,
[t_ccco] [char] (8) COLLATE Latin1_General_BIN NOT NULL,
[t_prre] [binary] (1) NOT NULL,
[t_copt] [binary] (1) NOT NULL,
[t_cprp] [float] NOT NULL,
[t_itmt] [binary] (1) NOT NULL,
[t_proi] [binary] (1) NOT NULL,
[t_cont] [binary] (1) NOT NULL,
[t_cntr] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_czed] [binary] (1) NOT NULL,
[t_reli] [char] (16) COLLATE Latin1_General_BIN NOT NULL,
[t_assi] [binary] (1) NOT NULL,
[t_potc] [real] NOT NULL,
[t_ffsi] [int] NOT NULL,
[t_qbsi] [float] NOT NULL,
[t_osyc] [binary] (1) NOT NULL,
[t_ufra] [binary] (1) NOT NULL,
[t_nobd] [smallint] NOT NULL,
[t_blcm] [float] NOT NULL,
[t_dcnt] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_frgt_c] [binary] (1) NOT NULL,
[t_dfrt_c] [binary] (1) NOT NULL,
[t_stup_c] [datetime] NOT NULL,
[t_sdat_c] [datetime] NOT NULL,
[t_pdat_c] [datetime] NOT NULL,
[t_txti_c] [int] NOT NULL,
[t_idat_c] [datetime] NOT NULL,
[t_hcod_c] [char] (16) COLLATE Latin1_General_BIN NOT NULL,
[t_upcc_c] [char] (16) COLLATE Latin1_General_BIN NOT NULL,
[t_size_c] [char] (30) COLLATE Latin1_General_BIN NOT NULL,
[t_srnb] [binary] (1) NOT NULL,
[t_srnr] [binary] (1) NOT NULL,
[t_comp] [binary] (1) NOT NULL,
[t_barc] [binary] (1) NOT NULL,
[t_pcat] [char] (10) COLLATE Latin1_General_BIN NOT NULL,
[t_ityp] [binary] (1) NOT NULL,
[t_fnsh] [binary] (1) NOT NULL,
[t_cwar_r] [char] (3) COLLATE Latin1_General_BIN NOT NULL,
[t_ppod] [binary] (1) NOT NULL,
[t_stat] [binary] (1) NOT NULL,
[t_osiz] [binary] (1) NOT NULL,
[t_ptyp] [char] (10) COLLATE Latin1_General_BIN NOT NULL,
[t_smul] [float] NOT NULL,
[t_owdt_c] [datetime] NOT NULL,
[t_qord] [binary] (1) NOT NULL,
[t_epbk] [binary] (1) NOT NULL,
[t_swgt] [float] NOT NULL,
[t_sdim] [char] (12) COLLATE Latin1_General_BIN NOT NULL,
[t_mcrt] [int] NOT NULL,
[t_mwgt] [float] NOT NULL,
[t_msiz] [char] (12) COLLATE Latin1_General_BIN NOT NULL,
[t_tcod] [char] (2) COLLATE Latin1_General_BIN NOT NULL,
[t_wrnt] [int] NOT NULL,
[t_Refcntd] [int] NOT NULL,
[t_Refcntu] [int] NOT NULL,
[hash1] [binary] (16) NOT NULL,
[hash2] [binary] (17) NOT NULL,
[hash3] [binary] (17) NOT NULL,
[hash4] [binary] (32) NOT NULL,
[hash5] [binary] (32) NOT NULL,
[hash6] [binary] (21) NOT NULL,
[hash7] [binary] (19) NOT NULL,
[hash8] [binary] (22) NOT NULL,
[hash9] [binary] (17) NOT NULL,
[hash10] [binary] (32) NOT NULL,
[hash11] [binary] (36) NOT NULL,
[hash12] [binary] (35) NOT NULL
) ON [PRIMARY]

[alexa]

Unfortunately, we were not able to reproduce this issue.

Could you please send us a screenshot of your dbForge Studio for SQL Server displaying the error message and clarify what action leads to the error message?

Please also provide us the version of the SQL Server server.

You can send the reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via that system.

[pintoj]

OK, I just sent an email to support.


Thanks!

[alexa]

We will keep further correspondence with you on this issue via our support system.