Issue Details (XML | Word | Printable)

Key: ODBC-136
Type: Bug Bug
Status: Closed Closed
Resolution: Won't Fix
Priority: Major Major
Assignee: Alexander Potapchenko
Reporter: Germán Ham M.
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
ODBC Driver

Error transfering data using Microsoft Project 2003 Professional.

Created: 24/Jan/12 04:04 AM   Updated: 31/May/12 03:27 PM
Component/s: None
Affects Version/s: None
Fix Version/s: 2.0.1

Environment: Windows 7, Sony Vaio VGN-CR160F


 Description  « Hide
I want to create database in firebird from Microsoft Project 2003 Professional. I Tried many times to configure connection and always show me error.
The command from microsoft Project is FILE + SAVEAS + ODBC + .....

No problems with Oracle or SQL Server.
Thanks.

 All   Comments   Change History   Subversion Commits      Sort Order: Descending order - Click to sort in ascending order
Alexander Potapchenko added a comment - 24/Jan/12 01:08 PM
AFAIK, Microsoft Project 2003 supports Oracle and SQL Server only - http://office.microsoft.com/en-us/project-help/file-formats-supported-by-project-HP045304550.aspx
Microsoft Project 2003 try to create tables with columns that Firebird doesn't support (DOUBLE, BIT, LONGCHAR)
For example
create table MSP_PROJECTS ( PROJ_ID INTEGER , PROJ_NAME VARCHAR ( 255 ) , PROJ_PROP_AUTHOR LONGCHAR ,
PROJ_OPT_CALC_ACT_COSTS BIT , PROJ_PROP_CATEGORY LONGCHAR , PROJ_PROP_COMPANY LONGCHAR ,
PROJ_OPT_CRITICAL_SLACK_LIMIT INTEGER , PROJ_OPT_CURRENCY_DIGITS SMALLINT , PROJ_OPT_CURRENCY_POSITION SMALLINT ,
PROJ_OPT_CURRENCY_SYMBOL VARCHAR ( 20 ) , PROJ_OPT_NEW_ARE_EFFORT_DRIVEN BIT , PROJ_INFO_CURRENT_DATE DATETIME ,
 PROJ_OPT_DEF_FINISH_TIME DATETIME , PROJ_OPT_DEF_FIX_COST_ACCRUAL SMALLINT , PROJ_OPT_MINUTES_PER_DAY INTEGER ,
 PROJ_OPT_MINUTES_PER_WEEK INTEGER , PROJ_OPT_DEF_OVT_RATE "DOUBLE" , PROJ_OPT_DEF_STD_RATE "DOUBLE",
  PROJ_OPT_DEF_START_TIME DATETIME , PROJ_OPT_DEF_TASK_TYPE SMALLINT , PROJ_OPT_DUR_ENTRY_FMT SMALLINT ,
  PROJ_INFO_FINISH_DATE DATETIME , PROJ_OPT_HONOR_CONSTRAINTS BIT , PROJ_PROP_KEYWORDS LONGCHAR ,
  PROJ_LAST_SAVED DATETIME , PROJ_PROP_MANAGER LONGCHAR , PROJ_OPT_MULT_CRITICAL_PATHS BIT ,
   PROJ_CREATION_DATE DATETIME , PROJ_POOL_ATTACHED_TO LONGCHAR , PROJ_INFO_CAL_NAME LONGCHAR ,
    PROJ_IS_RES_POOL BIT , PROJ_INFO_SCHED_FROM SMALLINT , PROJ_OPT_SPLIT_IN_PROGRESS BIT ,
     PROJ_OPT_SPREAD_ACT_COSTS BIT , PROJ_OPT_SPREAD_PCT_COMP BIT , PROJ_INFO_START_DATE DATETIME ,
     PROJ_INFO_STATUS_DATE DATETIME , PROJ_PROP_SUBJECT LONGCHAR , PROJ_PROP_TITLE LONGCHAR ,
     PROJ_OPT_TASK_UPDATES_RES BIT , PROJ_OPT_WORK_ENTRY_FMT SMALLINT , PROJ_OPT_CALC_SUB_AS_SUMMARY BIT ,
     PROJ_OPT_WEEK_START_DAY SMALLINT , PROJ_OPT_FY_START_MONTH SMALLINT , PROJ_OPT_FY_USE_START_YR BIT ,
     PROJ_OPT_DAYS_PER_MONTH SMALLINT , PROJ_OPT_NEW_TASK_EST BIT , PROJ_OPT_SHOW_EST_DUR BIT ,
     PROJ_OPT_EXPAND_TIMEPHASED BIT , PROJ_PROJECT VARCHAR ( 203 ) , PROJ_VERSION VARCHAR ( 50 ) ,
     PROJ_CREATION_DATE_EX DATETIME , PROJ_ACTUALS_SYNCH SMALLINT , PROJ_ADMINPROJECT SMALLINT ,
     PROJ_ENT_LIST_SEPARATOR VARCHAR ( 2 ) , PROJ_EXT_EDITED_DATE BIT ,
PROJ_EXT_EDITED_DUR BIT , PROJ_EXT_EDITED_NUM BIT , PROJ_EXT_EDITED_FLAG BIT )