Restituisci
-
Titolo
Generate List for Ticket System does not work -
Descrizione
Generate List reports the following error.
An error occured while testing the Ticket System. The results are: [mm/dd/yyyy hh:mm:ss] Executing Ticket System SQL Statement: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name \'TableName\'. (SQL-42S02) [state was 42S02 now 42000][Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000) -
Causa
The SQL query needs to be updated to specify the database name in the following format
Database.dbo.TableName -
Risoluzione
Instead of
Select * from TableName
Please useSelect * from Database.dbo.TableName