Access MS Project data via the Microsoft.Project.OLEDB.9.0 in ASP 
Author Message
 Access MS Project data via the Microsoft.Project.OLEDB.9.0 in ASP

In the appended ASP page, I get the following error.

error '80004005'
Unspecified error
/xmltest/prj_oledb.asp, line 19

Line 19 refers to the oConn.Open.
The project data lives on a SQL 2k server. I can reach the server if i use the SQLOLEDB provider, so i know the Username/Password, Data Source, Intial Catalog, and Server name field are all correct.

Any thoughts?

Thanks in advance,

-Frank

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


<%
 dim oConn
 dim oRS
 dim iCount
 dim sOut

 set oRS = server.CreateObject("ADODB.recordset")
 set oConn = server.CreateObject("ADODB.Connection")
 oConn.Provider = "Microsoft.Project.OLEDB.9.0"
 oConn.Properties("Data Source").Value = "WOLFSBANE"
 oConn.Properties("User ID").Value  = "foo"
 oConn.Properties("Password").Value  = "bar"
 oConn.Properties("Initial Catalog").Value = "devtest"
 oConn.Properties("PROJECT NAME").Value = "TestProject"
 oConn.ConnectionTimeout = 30
 oConn.Open

 dim sSQL
 sSQL = "SELECT ResourceUniqueID, AssignmentResourceID, AssignmentResourceName, TaskUniqueID, AssignmentTaskID," & _
         " AssignmentTaskName FROM Assignments WHERE TaskUniqueID < 0 ORDER BY AssignmentTaskID ASC"

 oRS.Open sSQL, oConn

 Do While Not rstAssigns.EOF
     For iCount = 0 To oRS.Fields.Count - 1
         sOut = sOut & "'" & oRS.Fields(iCount).Name & "'" & _
             Space(30 - Len(oRS.Fields(iCount).Name)) & vbTab & _
                 CStr(oRS.Fields(iCount).Value) & vbCrLf
     Next
     sOut = sOut & vbCrLf
     oRS.MoveNext
 Loop
oConn.Close
%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%=sOut%>
<P>&nbsp;</P>

</BODY>
</HTML>



Sat, 20 Dec 2003 01:49:15 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. ASP.NET update task in MS Project Server and MS Project

2. Q: VB4-32: Problems to load MS Project 4.1 project via OLE

3. Microsoft Project 2002 Database VS. Microsoft Project 2002 OLE DB Provider

4. Saving data in MS Project 98 to MS Access

5. MS Project 98 vs Ms Project 2000

6. Conversion from MS project 95 to MS project 2000

7. After adding tasks outside of MS Project, saving in MS Project deletes them

8. Pivot Table with Microsoft.Project.OLEDB.9.0

9. Deploy project using Microsoft.Jet.OLEDB.4.0

10. data exchange between MS Excel and MS Project

11. Can't open data control in MS Visual Basic Editor for MS project

12. Using MS Access to populate specific fields in MS Project

 

 
Powered by phpBB® Forum Software