Vicky,

could you please post an example query and the logged error from the error log (if any)?

And: I assume you are using Host :: SQL to run the queries, or is that wrong?

Best wishes
Michael

---

Hi
The problem arose from a SQL statement I use in OWS and this failed to work after the upgrade

SELECT number,picture,english,welsh from tblSelection JOIN tblPictures ON
tblSelection.OOO1 = tblPictures.Number
OR tblSelection.OOO2 = tblPictures.Number
OR tblSelection.OOO3 = tblPictures.Number
OR tblSelection.OOO4 = tblPictures.Number
where cast(cast(tblselection.StartDate as varchar(30)) as datetime) < getdate() AND getdate() < dateadd(day,7,cast(cast(tblselection.StartDate as varchar(30)) as datetime))


With an error related to 'invalid object name' on the table name tblSelection

So I ran the same query through Host > SQL and it runs on DNN 5.6.8 but not 7.2
So I ran a simple

select * from tblselection

through both sites - again 5.6.8 ok but 7.2 gives

Invalid object name 'tblselection'.


I hope that answers the questions but let me know if further info would be helpful
Thank you