# IBM.Data.DB2Types.DB2SmartLOB error **URL:** \ **Category:** Toad for IBM DB2\ **Created:** [May 17, 2016, 2:03pm UTC](https://forums.toadworld.com/t/ibm-data-db2types-db2smartlob-error/37735 "2016-05-17T14:03:45Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![rhpharr](https://avatars.discourse-cdn.com/v4/letter/r/eb9ed0/32.png) [@rhpharr](https://forums.toadworld.com/u/rhpharr)\ **Post date:** [May 17, 2016, 2:03pm UTC](https://forums.toadworld.com/t/ibm-data-db2types-db2smartlob-error/37735/1 "2016-05-17T14:03:45Z")
TOAD for DB2 v 6.0 IBM DB2 Client 10.1 Whenever I try to view data where a table has a DB2 datatype of CHARACTER FOR BIT DATA (Toad displays as CHARACTER(1)) I get this error: System.TypeLoadException Could not load type ‘IBM.Data.DB2Types.DB2SmartLOB’ from assembly ‘IBM.Data.DB2, Version=9.7.4.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208’. ---
**Author:** ![esheridan](https://avatars.discourse-cdn.com/v4/letter/e/779978/32.png) [@esheridan](https://forums.toadworld.com/u/esheridan)\ **Post date:** [May 17, 2016, 2:16pm UTC](https://forums.toadworld.com/t/ibm-data-db2types-db2smartlob-error/37735/2 "2016-05-17T14:16:28Z")
The error message lists DB2 Version 9.7.4.4. What is listed in Tools \> Options \> Database \> DB2 \> General \> DB2 Client? Thanks, Eric Sheridan ---
**Author:** ![rhpharr](https://avatars.discourse-cdn.com/v4/letter/r/eb9ed0/32.png) [@rhpharr](https://forums.toadworld.com/u/rhpharr)\ **Post date:** [May 18, 2016, 5:18am UTC](https://forums.toadworld.com/t/ibm-data-db2types-db2smartlob-error/37735/3 "2016-05-18T05:18:48Z")
DB2 Client: 10.1.0.872 ---
**Author:** ![rhpharr](https://avatars.discourse-cdn.com/v4/letter/r/eb9ed0/32.png) [@rhpharr](https://forums.toadworld.com/u/rhpharr)\ **Post date:** [May 18, 2016, 5:23am UTC](https://forums.toadworld.com/t/ibm-data-db2types-db2smartlob-error/37735/4 "2016-05-18T05:23:29Z")
![7343.toad_db2_version.jpeg](https://global.discourse-cdn.com/quest/original/2X/d/dc0c2d4423cc063db2fb27b768e1c05310803c01.jpeg) ![0410.odbc_db2_version.jpeg](https://global.discourse-cdn.com/quest/original/2X/0/05ee72a0c47656ecbae6e965f95e3f579cb9277b.jpeg) ---
**Author:** ![esheridan](https://avatars.discourse-cdn.com/v4/letter/e/779978/32.png) [@esheridan](https://forums.toadworld.com/u/esheridan)\ **Post date:** [May 18, 2016, 6:17am UTC](https://forums.toadworld.com/t/ibm-data-db2types-db2smartlob-error/37735/5 "2016-05-18T06:17:19Z")
The error message you are getting is from Toad. Look at the Options menu in Toad. ![Toad_Options.jpeg](https://global.discourse-cdn.com/quest/original/2X/2/24f65a1454e7c85703df1800048d7b8c45417135.jpeg) ---
**Author:** ![esheridan](https://avatars.discourse-cdn.com/v4/letter/e/779978/32.png) [@esheridan](https://forums.toadworld.com/u/esheridan)\ **Post date:** [May 18, 2016, 2:16pm UTC](https://forums.toadworld.com/t/ibm-data-db2types-db2smartlob-error/37735/6 "2016-05-18T14:16:05Z")
Also look at this forum post: [https://www.toadworld.com/products/toad-for-ibm-db2/f/18/t/23608](https://www.toadworld.com/products/toad-for-ibm-db2/f/18/t/23608) Thanks, Eric Sheridan ---
**Author:** ![rhpharr](https://avatars.discourse-cdn.com/v4/letter/r/eb9ed0/32.png) [@rhpharr](https://forums.toadworld.com/u/rhpharr)\ **Post date:** [May 19, 2016, 4:58am UTC](https://forums.toadworld.com/t/ibm-data-db2types-db2smartlob-error/37735/7 "2016-05-19T04:58:35Z")
Thanks, but in that post the person admits to running DB2 9.7.4.4. As I have shown with my screenshots (both the Toad config menu and the ODBC drivers), I am running 10.1.0. which is what TOAD 6.0 requires and is configured to use. ---
**Author:** ![esheridan](https://avatars.discourse-cdn.com/v4/letter/e/779978/32.png) [@esheridan](https://forums.toadworld.com/u/esheridan)\ **Post date:** [May 19, 2016, 6:12am UTC](https://forums.toadworld.com/t/ibm-data-db2types-db2smartlob-error/37735/8 "2016-05-19T06:12:16Z")
I understand that. However just like in the other post, the error message returned from Toad shows DB2 V9.7.4.4. The error message you provided in your original post shows: System.TypeLoadException Could not load type ‘IBM.Data.DB2Types.DB2SmartLOB’ from assembly ‘ **IBM.Data.DB2, Version=9.7.4.4** , Culture=neutral, PublicKeyToken=7c307b91aa13d208’. Is that not the correct error message you are getting? What version of DB2 does Toad say you are using, not ODBC? Have you opened a ticket with Dell? Thanks, Eric Sheridan ---
**Author:** ![rhpharr](https://avatars.discourse-cdn.com/v4/letter/r/eb9ed0/32.png) [@rhpharr](https://forums.toadworld.com/u/rhpharr)\ **Post date:** [May 19, 2016, 6:30am UTC](https://forums.toadworld.com/t/ibm-data-db2types-db2smartlob-error/37735/9 "2016-05-19T06:30:31Z")
No I have not opened a ticket with Dell yet and yes that is the error I’m receiving. Again, I have shown that Toad is configure for DB2 10.1.0. The reason I also show the ODBC screenshot is to show that I don’t have DB2 9.7.4 on my machine. This is a fresh build and has never had 9.7 installed. The only DB2 client installed is 10.1. ---
**Author:** ![esheridan](https://avatars.discourse-cdn.com/v4/letter/e/779978/32.png) [@esheridan](https://forums.toadworld.com/u/esheridan)\ **Post date:** [May 19, 2016, 6:44am UTC](https://forums.toadworld.com/t/ibm-data-db2types-db2smartlob-error/37735/10 "2016-05-19T06:44:21Z")
I missed that one screenshot. I would save all of your settings and configurations. Then uninstall Toad and reinstall it. Also you may want to try and upgrade your DB2 Client. It looks like it is the GA level of DB2 V10.1. The latest Fix Pack is Fix Pack 5. I would try going to that level. [http://www-01.ibm.com/support/docview.wss?uid=swg21610653](http://www-01.ibm.com/support/docview.wss?uid=swg21610653) If all of this still does not fix the issue then I would open a ticket up with Dell. Thanks, Eric Sheridan