Search

Ramchandra's Weblog

Just ……everything about DB2 LUW

Category

.NET

ERROR [IM003] Specified driver could not be loaded due to system error 5 (IBM DB2 ODBC DRIVER).

http://fresh-ant.blogspot.com/2007/04/error-im003-specified-driver-could-not.html

got an error while running the report

The issue was there is this ODBC Key in the registry, the current user
did not have read permission to read the key and the key told ASPNET
where the db2 odbc driver was, so as we cannot read the key we cannot
use the driver and hence cannot open a connection

  • An
    error has occurred during report processing.
    • Cannot
      create a connection to data source ‘NDB_MIG2’.
      • ERROR
        [IM003] Specified driver could not be loaded due to system error 5 (IBM DB2 ODBC
        DRIVER).

      Here is the solution
      1) I use DB2, ASP.Net with SSRS
      2) DSN is created in ODBC and sits on windows dsn,
      3)
      Run regedit and go to HKEY_LOCAL_MACHINE >> SOFTWARE >>
      ODBC >> ODBC.INI >> select the name of the dsn >>
      Right click permissions >> Add the user name underwhich IIS runs
      (or) the current logged in user and give him read access (i gave full
      control)

      4) Open mycomputer >> properties >>
      advanced tab >> Environmental Variables >> click path and
      add ;.; to the existing path at the end.
      5) Restart the machine, since it is a odbc change we need to restart pc.

Advertisements

sql server 2005 180 days trail

sql server 2005 180 days trail

http://download.microsoft.com/download/e/b/7/eb7e1ed9-2f27-4496-8160-21d793218dfe/SQLEVAL.EXE

visual studio team suit 2005 180 days trail download

visual studio team suit 2005 180 days trail download
http://download.microsoft.com/download/6/f/5/6f5f7a01-50bb-422d-8742-c099c8896969/En_vs_2005_vsts_180_Trial.img

visual studio 2008 90 days trail download

visual studio 2008 90 days trail download

http://download.microsoft.com/download/e/0/4/e04de840-8f6b-4fe5-ac3d-d3ad8e4c2443/En_vs_2005_Pro_90_Trial.img

Visual Basic .NET 2008 Express – Tutorial

Visual Basic .NET 2008 Express – A “From the Ground Up” Tutorial

Blog at WordPress.com.

Up ↑