
If you were logged in you would be able to see more operations.
|
|
|
Environment:
|
Windows 7, Sony Vaio VGN-CR160F
|
|
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.
|
Description
|
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. |
Show » |
|
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 )