SQL tidy up causing problems...

[afranka]

Hi,

I have a site linked to an SQL database via a dsn.
I am trying to remove a field from the sql database, but keep getting the following error:

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

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Full_Name'.

/index.asp, line 27

I have tried deleting the DSN and recreating, but it doesn't fix it!
Is there a file somewhere that I have to manually update?
Please can someone help?
(If it helps I am using Ultradev).

Thanks,
al.

[glenngv]

you have SQL statement(s) in index.asp page that access the field Full_Name which you deleted.

[afranka]

That's what thought, but I have searched the page and there is nothing there!

Line 27 on index.asp is: the line "Introducing.Open()".

<%
set Introducing = Server.CreateObject("ADODB.Recordset")
Introducing.ActiveConnection = MM_Phonebook_STRING
Introducing.Source = "SELECT Name, Surname, Role_1, Ofice_Name, BG_Name, BP_Name, Location, Pict_link, Interests, Detail_link FROM dbo.WMPhonebook WHERE Employeeid = " + Replace(Introducing__MMColParam, "'", "''") + ""
Introducing.CursorType = 0
Introducing.CursorLocation = 2
Introducing.LockType = 3
Introducing.Open()
Introducing_numRows = 0
%>

Any thoughts?

[raf]

the errorcode is clear, so check the sql statement.

might also be something stupid like a cached file on your server/box (had it once on a developmentserver and i costed me a lott of time ...)