Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 :

 DB2Option.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

 

1 ACCEPTED SOLUTION
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.

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

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

 

Maybe an error with language connection ?

 

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
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.

Hi @Anonymous,

 

>>When I add a CAST VARCHAR on DATE columns, I have no more problem.

If it only appears when you use date type, I think the issue may related to it. Which date format you used to stored these time value? Can you share some sample?

 

Notice: Current power bi not support to analysis specify timestamp format. If this is a case, I'd like to suggest you convert them to normal date format before import.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

Yes, it's only with DATE type.
You can find above field list of the table, so i think it's DATE format. Field are like '26/11/2017'.

With a view making the cast all is good, but it's odd.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.