Forum Discussion
IBM DB : Microsoft DB2 client method not found. SQLSTATE=HY000 SQLCODE=-343
- 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.
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
- 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