Search code examples
db2odbcdb2-400db2-luwpolybase

IBM DB2 ODBC DRIVER :: SQL1390C The environment variable DB2INSTANCE is not defined or is invalid

I've followed several guides online and I cannot install IBM DB2 ODBC DRIVER on Windows.

I have downloaded the driver from IBM and installed (which was quite a roller-coaster).

If I follow guide1 or guide2 the result is the same:

SQL1390C The environment variable DB2INSTANCE is not defined or is invalid

enter image description here

Note: this is my C:\Program Files\IBM folder and as you can see there is no bin folder

enter image description here

Not sure if db2oreg1.exe -setup is still mandatory, things might have changed.

Solution

  • Thanks to @MarkBarinstein I found where the problem was.

    I've followed this guide How to install IBM db2 ODBC driver in Windows 7 - 64 bit? and I downloaded the wrong package: I downloaded the universal_fixpack instead of the client.

    I realized that when I saw the two folders in the Download directory:

    enter image description here

    So I uninstalled the universal_fixpack and installed the client and the installation was successful.