Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

IBM DB : Microsoft DB2 client method not found. SQLSTATE=HY000 SQLCODE=-343

Hello,

 

I'm using Power BI x86 and Microsoft Driver for connecting to IBM DB2 server.

 

For using connection, I unmarked 2 boxes :

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I can use a lot of table without problem.

But with one of them, i have the error above :

 

DataSource.Error : Microsoft Db2 Client : Method not found: 'System.String System.String.Format(System.IFormatProvider, System.String, System.Object)'. SQLSTATE=HY000 SQLCODE=-343
Détails :
    DataSourceKind=DB2
    DataSourcePath=MyServer.prod.MyDomain.fr:50000;MyDB
    Message=Method not found: 'System.String System.String.Format(System.IFormatProvider, System.String, System.Object)'. SQLSTATE=HY000 SQLCODE=-343
   ErrorCode=0

 

The table structure is this one :

"DATE_KEY" INTEGER NOT NULL ,
"FSC_DIM_WEEK_NUM" INTEGER ,
"CAL_DIM_MONTH_NUM" INTEGER ,
"CAL_DIM_QTR_NUM" INTEGER ,
"CAL_DIM_YEAR_NUM" INTEGER ,
"FSC_DIM_QTR_NUM" INTEGER ,
"FSC_DIM_YEAR_NUM" INTEGER ,
"CAL_MONTH_DAY_NUM" SMALLINT ,
"CAL_YEAR_DAY_NUM" SMALLINT ,
"CAL_DAY_STR" VARCHAR(30) ,
"CAL_DAY_FLAG" VARCHAR(30) ,
"CAL_DAY_DT" DATE ,
"CAL_YEAR_MONTH_NUM" SMALLINT ,
"CAL_MONTH_STR" VARCHAR(30) ,
"CAL_MONTH_START_DT" DATE ,
"CAL_MONTH_END_DT" DATE ,
"CAL_MONTH_FLAG" VARCHAR(30) ,
"CAL_MONTH_END_FLAG" CHAR(1) ,
"CAL_YEAR_QTR_NUM" SMALLINT ,
"CAL_QTR_STR" VARCHAR(30) ,
"CAL_QTR_START_DT" DATE ,
"CAL_QTR_END_DT" DATE ,
"CAL_QTR_FLAG" VARCHAR(30) ,
"CAL_QTR_BEGIN_FLAG" CHAR(1) ,
"CAL_QTR_END_FLAG" CHAR(1) ,
"CAL_MONTH_WEEK_NUM" SMALLINT ,
"CAL_YEAR_WEEK_NUM" SMALLINT ,
"CAL_DIM_WEEK_NUM" INTEGER ,
"CAL_WEEK_STR" VARCHAR(30) ,
"CAL_WEEK_START_DT" DATE ,
"CAL_WEEK_END_DT" DATE ,
"CAL_WEEK_FLAG" VARCHAR(30) ,
"CAL_YEAR_STR" VARCHAR(30) ,
"CAL_YEAR_START_DT" DATE ,
"CAL_YEAR_END_DT" DATE ,
"CAL_YEAR_FLAG" VARCHAR(30) ,
"CAL_DAY_OF_WEEK" VARCHAR(30) ,
"FSC_MONTH_DAY_NUM" DECIMAL(2,0) ,
"FSC_YEAR_DAY_NUM" DECIMAL(3,0) ,
"FSC_DAY_STR" VARCHAR(30) ,
"FSC_MONTH_NUM" SMALLINT ,
"FSC_DIM_MONTH_NUM" INTEGER ,
"FSC_MONTH_STR" VARCHAR(30) ,
"FSC_MONTH_START_DT" DATE ,
"FSC_MONTH_END_DT" DATE ,
"FSC_MONTH_FLAG" VARCHAR(30) ,
"FSC_MONTH_END_FLAG" CHAR(1) ,
"FSC_QTR_NUM" SMALLINT ,
"FSC_QTR_STR" VARCHAR(30) ,
"FSC_QTR_START_DT" DATE ,
"FSC_QTR_END_DT" DATE ,
"FSC_QTR_FLAG" VARCHAR(30) ,
"FSC_QTR_BEGIN_FLAG" CHAR(1) ,
"FSC_QTR_END_FLAG" CHAR(1) ,
"FSC_MONTH_WEEK_NUM" SMALLINT ,
"FSC_YEAR_WEEK_NUM" SMALLINT ,
"FSC_WEEK_STR" VARCHAR(30) ,
"FSC_WEEK_START_DT" DATE ,
"FSC_WEEK_END_DT" DATE ,
"FSC_WEEK_FLAG" VARCHAR(30) ,
"FSC_YEAR_STR" VARCHAR(30) ,
"FSC_YEAR_START_DT" DATE ,
"FSC_YEAR_END_DT" DATE ,
"FSC_YEAR_FLAG" VARCHAR(30) ,
"PAST_FLAG" CHAR(1) ,
"HOLIDAY_FLAG" CHAR(1) ,
"WEEKDAY_FLAG" CHAR(1) ,
"CAL_WORK_DAY_NUM" INTEGER ,
"FSC_WORK_DAY_NUM" INTEGER ,
"ALL_WORK_DAY_NUM" INTEGER ,
"SEASON_TEXT" VARCHAR(254) ,
"EVENT_1_TEXT" VARCHAR(254) ,
"EVENT_2_TEXT" VARCHAR(254) ,
"EVENT_3_TEXT" VARCHAR(254) ,
"EVENT_4_TEXT" VARCHAR(254) ,
"DATE_ATTR1_CODE" VARCHAR(30) ,
"DATE_ATTR1_NAME" VARCHAR(254) ,
"DATE_ATTR2_CODE" VARCHAR(30) ,
"DATE_ATTR2_NAME" VARCHAR(254) ,
"DATE_ATTR3_CODE" VARCHAR(30) ,
"DATE_ATTR3_NAME" VARCHAR(254) ,
"DATE_ATTR4_NAME" VARCHAR(254) ,
"DATE_ATTR5_NAME" VARCHAR(254) ,
"DATE_ATTR6_NAME" VARCHAR(254) ,
"CDC" INTEGER ,
"INVOICE_NUMBER" INTEGER ,
"INVOICE_START_DT" DATE ,
"INVOICE_END_DT" DATE 

Is there something wrong with this one ?

Or maybe into data and not structure ?

 

Thanks for help,

Alexandre.

 

  • Anonymous's avatar
    Anonymous
    8 years ago
    Thanks for the link but i suppose it's about connection problem and not specific data access.

    When I add a CAST VARCHAR on DATE columns, I have no more problem.
    So problem with data or problem with dirver ?

    Thanks,
    Alexander.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    I have more precision : I have this error only with column in DATE format.

     

    Maybe an error with language connection ?

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous,

       

       

      Maybe you can take a look at below link which about link to IBM datasoure.

      Cannot connect to AS400 via IBM DB2 database

       

      In addition, if you use additional t-sql query to remove date type columns and try again, does this issue appears again?

       

      Regards,

      Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        Thanks for the link but i suppose it's about connection problem and not specific data access.

        When I add a CAST VARCHAR on DATE columns, I have no more problem.
        So problem with data or problem with dirver ?

        Thanks,
        Alexander.