Connect Project 2007 to SQL
-
יום שלישי 08 יוני 2010 12:42
Is it posible to connect from Project 2007 to SQL, without installing Project Server 2007?
Thanks for support.
כל התגובות
-
יום שלישי 08 יוני 2010 12:54מנחה דיון
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- סומן כתשובה על-ידי Dusan Krizman, MCTS יום שלישי 22 יוני 2010 15:11
-
יום שלישי 08 יוני 2010 13:04
I tel you if it works.
-
יום שלישי 08 יוני 2010 18:41בעלים
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- סומן כתשובה על-ידי Christophe FiessingerMicrosoft Employee, Owner יום שלישי 08 יוני 2010 18:41
-
יום שלישי 22 יוני 2010 15:22
We need data from SQL (ERP sistem) to put into Project file. Project server is too expensive solution.
-
יום שלישי 22 יוני 2010 16:50מנחה דיון
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- סומן כתשובה על-ידי Dusan Krizman, MCTS יום רביעי 23 יוני 2010 17:29