I am fighting with an issue with SQL Server 7.0 & Cold Fusion 4.5.1.  I am getting the error below but the table does exist on the SQL server database & the DSN is setup and working & my query is fine.  I feel like this is an ownership problem but I don't have a clue what would have caused it.  Any one out there an expert in SQL Server ?
 
Error Message:
ODBC Error Code = S0002 (Base table not found)

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Errors'.

-------------------------------------------------------------------------------

SQL Query:
<cfquery name="GetVitalQuestions" datasource="#DSN#" username="#User#" password="#Pass#">
  SELECT *
  FROM VitalQuestions

Reply via email to