ODBC "Open" data displayed incorrectly.

[Snake]

I have been trying to "Open" an ODBC data source which is a Sql Server 2000
table. The datetime columns contain around-the-clock values, and the
RunDuration column contains minutes (have tried float and integer types.) I
set the timescale to Minutes/10.

Create table JobHistory (Name Varchar(64), (Name)
RunDuration float, (Duration)

RunDateTime DateTime, (Start)
EndDateTime DateTime) (Finish)

Gant Chart shows "Point" length tasks. The DateTime columns are always
interpreted by Project as AM time, never PM. Also, RunDuration is in
minutes, and it appears to be sometimes ignored or the decimal place is
slipped one to the left (ex. 29.0 becomes 2.9). I have tried different
permutations of column-to-Project mappings but nothing changes for the
better.

Is this another feature that simply does not work or are there some obscure
settings which allow MS Project to work with MS Sql Server? I believe that
the ODBC dri vers were also provided by MS.

Best regards

 

[Snake]

I eventually found settings which modify start/finish date/times when data is
imported. I also found that the minimum task duration is 1 minute, so
durations less than a minute become zero duration. The only remaining issue
is that the durations being imported have to be multiplied by 10 in order to
import the correct value.

 

[Rod Gill]

The pjdb.htm file in one of project's folders will tell you all you need to
know.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com