Connect Project 2007 to SQL
-
Dienstag, 8. Juni 2010 12:42
Is it posible to connect from Project 2007 to SQL, without installing Project Server 2007?
Thanks for support.
Alle Antworten
-
Dienstag, 8. Juni 2010 12:54Moderator
Yes, it should be, although I haven't seen it done personally.Check out the Open options, and you'll see an option to open via ODBC. Tosave, check out Visual Reports, Save Data, and that will give you the optionto save as a database.This may also contain relevant information: http://msdn.microsoft.com/en-us/library/ms436148(office.12).aspx- Andrew Lavinsky- Als Antwort markiert Dusan Krizman, MCTS Dienstag, 22. Juni 2010 15:11
-
Dienstag, 8. Juni 2010 13:04
I tel you if it works.
-
Dienstag, 8. Juni 2010 18:41Besitzer
the ODBC option does not work and should not be present. The main question is why not use Project Server to leverage out of the box functionality to manage a central reposity with project plans, resources etc...? Doing customization is great but why not look at the Total Cost of Ownership and evaluate Project Server.
Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page- Als Antwort markiert Christophe FiessingerMicrosoft Employee, Owner Dienstag, 8. Juni 2010 18:41
-
Dienstag, 22. Juni 2010 15:22
We need data from SQL (ERP sistem) to put into Project file. Project server is too expensive solution.
-
Dienstag, 22. Juni 2010 16:50Moderator
That's either a custom app written perhaps as VBA or a third party tool.Check with your ERP vendor to see if they have a Project client integration.A lot of vendors have one.- Andrew Lavinsky- Als Antwort markiert Dusan Krizman, MCTS Mittwoch, 23. Juni 2010 17:29