[#ODBC-136] Error transfering data using Microsoft Project 2003 Professional.

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:

[ Permalink | « Hide ]

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 )

[ Show » ]

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 )