Project Server Version

#1

Could you let me know with what Version of Project Server is Aspose.Project supports.

The Reason i am asking this is that i am working with the 2003 version of Project Server an I am using MPDProject class to save project settings to SQL Server Database.

When trying to save project settings to the database iget the following error

System.Data.OleDb.OleDbException: Invalid column name ‘+’.



I used the following code to save project settings

Dim db As MPDDatabase = New MPDDatabase(“Provider=sqloledb;Data Source=XXX;Initial Catalog=ProjectServer4889;User Id=XXX;Password=XXX;”)

Dim projectInfo As MPDProjectInfo = db.Item(8)

Dim project As MPDProject = db.ReadMPDProject(projectInfo)

project.Project.Title = “i-DontKnow”

project.Write()

Could you help me with the above problem

Thanks

Binu Mathew


#2

Dear Mathew,

I was tested with MS Project 2000 and 2003 (MS SQL 2000).
Could you tell me please what database you use and version of .Net framework?

#3

The Database Version is SQL Server 2000

The .NET Framework version is 1.1

Thanks

Binu Mathew

#4

I am also posting the Stack Trace from the exception thrown by the error

[OleDbException (0x80040e14): Invalid column name ‘+’.]
System.Data.OleDb.OleDbDataReader.NextResults(IMultipleResults imultipleResults, OleDbConnection connection, OleDbCommand command)
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
Aspose.Project.MPDProject.d()

[ProjectDBWriteResourceException: Error writing resource to a database]
Aspose.Project.MPDProject.d()
Aspose.Project.MPDProject.Write()
Aspose.CreateProject.generateBtn_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\ASPOSE\CreateProject.aspx.vb:203
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()

#5

Dear Mathew,

Please, could you try little changed version and write me about results?
http://www.aspose.com/Products/Aspose.Project/Fixes/Aspose.Project.1.2.1.1.zip

#6

Yes i Do not get the Exception anymore, It seems to be working, I am going to do some more testing