OLE IDispatch 1004 Error: Saving Ms Project 2003 to SQL 2000 using ODBC

M

Mike

I am using Visual Fox Pro 6, and have COM code to open, recalc and save
projects saved in SQL 2000.

I keep getting this error (at random, from diffent projects) returned to fox
from Project Pro 2003 (SP2) when I am saving the project back to SQL 2000
using the ODBC.

Error:
OLE IDispatch exception code 1004 from Microsoft Office Project: An
unexpected error occurred during command execution...

When I go back and check the Project that was being saved, it is no longer
in the SQL database. (gone, even the header record in MSP_PROJECTS) it seems
to have aborted the save completely and not saved anything, but also wiped
the existing project that I was trying to save.


Does anyone have any ideas what this error might be related to?
I have tried searching IDispatch 1004 on google and MSDN but no ideas what
it might be related to.
I have loaded service pack 2 for project 2003
I have loaded mdac 2.8

Thanks in advance

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top