April 12, 2007 at 10:12 pm
i have created a Microsoft project plan file, mmp file, using the Microsoft project office. and i create a linked server using [sp_addlinkedserver] to this file using the prvider Microsoft.Project.11.0. and specify in the catalog the file name.
the problem i am facing now that whne i write a select statment to get data from the tables in this linked server, it shows an error that says
"Could not obtain a required interface from OLE DB provider 'Microsoft.Project.OleDB.11.0'."
"[OLE/DB Provider 'Microsoft.Project.OleDB.11.0' IUnknown::QueryInterface returned 0x80004002: IGetDataSource]"
can anybody send me what is the problem and what are the steps to solve such a probblem
June 4, 2010 at 10:45 am
Hi ,
I am new to this forum> Can you please suggest me step to Link .MPP (MS Project 2003) file to SQL. server 2005.
I tried to create linke server from SSMS. It create linkserver but faile to test connection.
I used Server Name MSP_Test
Provide : Microsoft.Project.OLEDB.11.0
Product Name : Microsoft Project 2003
Data Source : C:\Test.mpp
Can you please let me know If I am worng in above steps.
Thanks a ton, from last few weeks I stuck here and can't move forward with my work 🙁 🙁 please help me.
June 8, 2010 at 9:21 am
http://www.connectionstrings.com/ms-project
Do you have MS Project 2003 SP3 installed?
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 8, 2010 at 10:18 am
Thank you Thomas,
Yes I have installed MS Project 2003 SP3.
I have other new issue:
If we use Microsoft.Project.OLEDB.11.0 library (MDAC2.8) in VB.net application, after shipping to end use, It prompts Microsoft.Project.OLEDB.11.0 is not registered( its right because end user might be will not have msp 2003 installed). Is there anyway we can ship complete deployement pkg to endused like prerequerites?
June 8, 2010 at 12:24 pm
gsingh0904 (6/8/2010)
I have other new issue:If we use Microsoft.Project.OLEDB.11.0 library (MDAC2.8) in VB.net application, after shipping to end use, It prompts Microsoft.Project.OLEDB.11.0 is not registered( its right because end user might be will not have msp 2003 installed). Is there anyway we can ship complete deployement pkg to endused like prerequerites?
You can, in your VB.NET solution, create an additional project. Create a deployment project, and make sure that you add in all the extra bits and bats you require - MDAC, MPP libraries etc. This is wandering off topic, so I'll just suggest (as a starting point) a quick read of http://msdn.microsoft.com/en-us/library/ms994427.aspx - Using Visual Studio .NET to Redistribute the .NET Framework that covers a lot of the points you need to know here.
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 9, 2010 at 1:12 am
Thanks a lot Thomas for you help!!!,
I am creating new project and read from microsoft link as you suggested.I will update you for my success.
Mean while can we cover topic for Linked server .mpp to SQL server 2005. As you asked ,I have installed SP3 for ms project 2003 but still I am not able to test linked server connection with .mpp 🙁 please suggest if any?
June 9, 2010 at 1:15 am
gsingh0904 (6/9/2010)
Mean while can we cover topic for Linked server .mpp to SQL server 2005. As you asked ,I have installed SP3 for ms project 2003 but still I am not able to test linked server connection with .mpp 🙁 please suggest if any?
Assuming everything's set up on the server correctly, the only other thing I can think of to check is that the SQL Server service account has access to the MPP file in question.
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 9, 2010 at 2:23 am
Hi Thomas,
How we can check if mpp has sql server acct permission or not? Do I need to add any user to that file? if so, how can we achive this?
June 9, 2010 at 2:31 am
gsingh0904 (6/9/2010)
Hi Thomas,How we can check if mpp has sql server acct permission or not? Do I need to add any user to that file? if so, how can we achive this?
Look at the MPP file's security properties. See if the SQL Server user account is able to read the file and the directory in which the file resides. Try using the xp_fileexist SP. There's a discussion here - http://www.sqlservercentral.com/Forums/Topic533876-146-1.aspx%5B/url%5D.
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 9, 2010 at 3:40 am
It returned 0,0,0. I looked many account are there Start with SQLServer2005MS**** , which account we have to give accesss? I tried to give full access to 'Everyone' account but still fails to test connection 🙁
June 9, 2010 at 3:44 am
gsingh0904 (6/9/2010)
It returned 0,0,0. I looked many account are there Start with SQLServer2005MS**** , which account we have to give accesss? I tried to give full access to 'Everyone' account but still fails to test connection 🙁
You need to make sure that the account under which the SQL Server service (and, for a scheduled task, the account that is used by the SQL Server Agent) has permissions. Check in the Control Panel - Services database to see which account names to allow access to the MPP file & directory path.
Thomas Rushton
blog: https://thelonedba.wordpress.com
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply