Incorrect Data from ODBC/Sql Server 2000 table.

[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.

Am I wasting my time with Project? 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 want to make this work but sheesh! This should be
easy!

Best regards

 

[Mike Glen]

Hi Snake,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP