Unexpected NULL value returned for the column

• S Srinivas-288569

  SSC Rookie

  Points: 37

  More actions

  December 22, 2005 at 9:35 pm

  #90267

  Hello all,

  We have an ASP application working on on IIS 6.0 with backend SQLSERVER 2000 in our Intranet.

  Recently we have migrated our application to another server which is on the internet with its own database server at another location.

  the application needs fulltext indexing. so after migration to the new server we have done fulltext indexing with the same name as done on the intranet.

  But the problem is that in the new location its throwing the following error

  Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

  [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [Non-interface error: Unexpected NULL value returned for the column: ProviderName='Full-text Search Engine', TableName='[FULLTEXT:SATSource1]', ColumnName='KEY'].

  but the thing is that there is no column named KEY in the table

  here is the script for the table

  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SATSource1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

  drop table [dbo].[SATSource1]

  GO

  CREATE TABLE [dbo].[SATSource1] (

   [ID] [decimal](18, 0) NOT NULL ,

   [EDATE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [RSTAT] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [RRN] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [BENT] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [BLVL] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [LIND] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [AU] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [VAU] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [AFFL] [nvarchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [ACRP] [nvarchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [TITL] [nvarchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [COLAT] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [MAU] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [MCRP] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [MTITL] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CNAME] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CPLC] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CDATE] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [EDITN] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [ISBN] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [RNUMB] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [PUBL] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CONTRY] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [PDATE] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [MCOLAT] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CTITL] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [STI] [nvarchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [ISSN] [nvarchar] (33) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [VOL] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [ISSUE] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [LANG] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [SLANG] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [NOTES] [nvarchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [MEDIUM] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [LIB] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [BOOKNO] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [ACCN] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [SOURCE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [AVAIL] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [GCODE] [nvarchar] (77) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CLASS] [nvarchar] (77) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CINDY] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [DE] [nvarchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [SINDX] [nvarchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [ABS] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [DEGR] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [SC] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

  GO

  any help is appreciated .

  regards

  srinivas

• December 26, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Bill Scott

  SSCrazy

  Points: 2338

  More actions

  December 27, 2005 at 9:37 am

  #611552

  are your ANSI NULLs set the same on both machines?