Skip site navigation (1) Skip section navigation (2)

Migrating Microsoft Project Files to PostgreSQL

From: "Sandahl, Dan" <Dan(dot)Sandahl(at)TriPointGlobal(dot)com>
To: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Migrating Microsoft Project Files to PostgreSQL
Date: 2004-09-27 18:44:37
Message-ID: AADF63190EF73C44BBA036605CBF8FB013EF0A@hermes.vertexrsi.net (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello,

I am currently in the process of trying to migrate from using Microsoft
Project 2002 files (for storing project details) to using PostgreSQL
database.  However, I have not been able to do this successfully.

When I try to use the ODBC driver, I initially got an error message about
'lo' not being in the catalog of available types.  (This was corrected, by
following the instructions listed in the ODBC FAQ.
http://gborg.postgresql.org/project/psqlodbc/faq/faq.php?faq_id=52)

After correcting the 'lo' problem, I started receiving the error:

	ERROR:  Relation 'msp_projects_proj_opt_minut_seq' already exists.

I was successfully able to get around the relation error message by deleting
my original database and creating a new one.  I then ran the
msproject2000.sql commands located in
http://techdocs.postgresql.org/sql/msproject2000.sql.

After completing the msproject2000.sql operations, I again tried to save a
Project file to the PostgreSQL via ODBC.  However, after about 5 to 10
seconds of saving data, Microsoft Project crashes from within the
pj10od10.dll.

Microsoft Project 2002 (Version 10.0.2104.1305) SP-1
PostgreSQL (Version 7.2)
PSQLODBC (Version 7.03.0200)

Any suggestions?

Thank you,
Daniel J. Sandahl
--
Daniel J. Sandahl <Dan(dot)Sandahl(at)tripointglobal(dot)com>
VertexRSI - Controls & Structures Division
1915 Harrison Road; Longview, Texas 75604-5438
(903) 295-1480 x221  --  FAX:  (903) 295-1479

pgsql-odbc by date

Next:From: Greg CampbellDate: 2004-09-27 18:55:28
Subject: Re: basic questions with odbc and visual basic.
Previous:From: Merlin MoncureDate: 2004-09-27 18:43:44
Subject: Re: basic questions with odbc and visual basic.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group