J
João Martins
Hi there,
I've been working on a project with similar functions and
I think this might help:
1-If you have sql server and msproject, you're set.
2-Use an ASP component (such as ASPUpload) for uploading
mpp files.
3-Check if you have the necessary permitions to open an
MSProject file through ASP - start by going to Run-
isn't a big issue at this stage, make everything as loose
as possible, then tighten settings after you get things
to work
4-Include the Project object library as a reference for
your project.
5-To save to database, first you need to open the mpp
file, so:
set x=CreateObject("MSProject.Application")
x.FileOpen "pathandfilename.mpp"
6-Then you'll want to save it:
s="<(SQL Server);server=
(local);database=dbname;DSN=dsnname-without-
extension>\projectfilename"
a=x.FileSaveAs
(s,pjmpp,false,false,true,false,"",databaseusername,databa
sepassword,"msproject.odbc")
x.quit
I hope it works for you!
João
I've been working on a project with similar functions and
I think this might help:
1-If you have sql server and msproject, you're set.
2-Use an ASP component (such as ASPUpload) for uploading
mpp files.
3-Check if you have the necessary permitions to open an
MSProject file through ASP - start by going to Run-
and edit the Default Security settings also. If security
isn't a big issue at this stage, make everything as loose
as possible, then tighten settings after you get things
to work
4-Include the Project object library as a reference for
your project.
5-To save to database, first you need to open the mpp
file, so:
set x=CreateObject("MSProject.Application")
x.FileOpen "pathandfilename.mpp"
6-Then you'll want to save it:
s="<(SQL Server);server=
(local);database=dbname;DSN=dsnname-without-
extension>\projectfilename"
a=x.FileSaveAs
(s,pjmpp,false,false,true,false,"",databaseusername,databa
sepassword,"msproject.odbc")
x.quit
I hope it works for you!
João