Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error transfering data using Microsoft Project 2003 Professional. [ODBC136] #133

Closed
firebird-automations opened this issue Jan 24, 2012 · 3 comments

Comments

@firebird-automations
Copy link

Submitted by: Germán Ham M. (germanham)

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.

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

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 )

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Won't Fix [ 2 ]

Fix Version: 2.0.1 [ 10430 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants