Free Support Forum -

Can't read from ODBC Source using MS Project Professional 2002

Below is the output generated from the Sample Database program. It finds the project but returns an error when trying to read it. We have a rather large library of projects in our SQL server database and would like to be able to manipulate them using this tool. Is there something I need to do to get this working?

Name: Project1
Start Date: 11/1/2005 8:00:00 AM
Finish Date: 11/30/2005 5:00:00 PM
Aspose.Project.ProjectDBReadResourceException: Error reading resource from a dat
abase ---> System.Data.OleDb.OleDbException: Invalid column name 'RES_CREATION_D
at System.Data.OleDb.OleDbDataReader.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbDataReader.NextResult()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behav
ior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.ExecuteReader()
at Aspose.Project.MPDProject.x5dce7d7f357d26dc(Hashtable x3839abade449ea8e)
--- End of inner exception stack trace ---
at Aspose.Project.MPDProject.x5dce7d7f357d26dc(Hashtable x3839abade449ea8e)
at Aspose.Project.MPDProject.x5d3a1f6283012a22()
at Aspose.Project.MPDProject..ctor(OleDbConnection conn, MPDProjectInfo pinfo
, Boolean use_decimals, String connect_str)
at Aspose.Project.MPDDatabase.ReadMPDProject(MPDProjectInfo pinfo)
at Database.Query() in c:\program files\aspose\aspose.project\demos\c#\databa
se\database.cs:line 91


Standard Project database should have RES_CREATION_DATE column in MSP_RESOURCES table.