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
Note: this is my C:\Program Files\IBM folder and as you can see there is no bin folder
Not sure if db2oreg1.exe -setup is still mandatory, things might have changed.
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:
So I uninstalled the universal_fixpack and installed the client and the installation was successful.
- Querying DB2 every 15 seconds causing memory leak in NodeJS
- To get the previous record which is less than the given date and time
- An arithmetic expression with a DATETIME value is invalid while using PreparedStatement with Arithmetic calculation in sql later
- No authorized routine named "GETVARIABLE" of type "FUNCTION" having compatible arguments was found
- Get columns of index on DB2
- Unable to convert bytes from charset 65535 in to Japanese (5035)
- ibmcom/db2 docker image fails on m1
- IBMi SQL stored procedures - how to set comma / decimal point in numbers
- as400 (IBMi) journals for analysis
- IBM Db2 Query Not Returning Expected Results for JSON Array Objects
- How to split a string value based on a delimiter in DB2
- How to concat an integer value with a string in DB2 procedure
- Calculating Cumulative Percentages in SQL
- Calculating average number of days between two events
- Where are IBM's DB2 and Oracle's SQLJ Translators?
- Keeping the entire set of duplicates with the highest year (per name)
- Dividing Overlapping Periods in SQL
- SQL: Keeping One Instance of Each Duplicate Set
- Analyzing Gap Years in SQL
- restore an ibm db2 from a savf file
- Checking for Differences between Tables and Making Changes
- SQL get one result of counted column
- Translate to foreign languages in SQL query
- Error when extracting YYMMDD dates from table in AS/400
- SQL join, display multiple values into one row
- DB2 With clause conditional select
- Files stay open after close in SQLRPGLE
- DB2 return table in function
- IBM DB2 ODBC DRIVER :: SQL1390C The environment variable DB2INSTANCE is not defined or is invalid
- Set a column unique without being the primary key