FWE DB2 Settings
NOTE Using Database2 key = DSN mode
######################################################### # ODBC Settings (Tested with iODBC, unixODBC and Windows) ######################################################### Database2 = DB2web Username = db2inst1 Password = password Server = 127.0.0.1 Port = 50000 Prefix = fwe ######################################################### # DATABASE SPECIFIC PARAMETERS (1 PER LINE) ######################################################### Param = LongDataCompat=1 Param = LOBMaxColumnSize=102400 ######################################################### # So we are SQL Compatible with the SQL syntax your using ######################################################### SQL_INT32 = integer SQL_CONTENT = clob SQL_TITLES = varchar
ODBC.INI
[DB2web] Driver = DB2
ODBCINST.INI
[ODBC] Trace = No TraceFile = /tmp/sql.log [DB2] Description = DB2 Driver on a Linux machine Driver = /opt/ibm/db2/V9.7/lib32/libdb2.so FileUsage = 1 DontDLClose = 1
HTTPD.CONF
You will also need to add to your httpd.conf file in the Global Environment section:
SetEnv DB2INSTANCE db2inst1
And that will avoid:
[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
Search Engine
Topics Linked to here
Topics this links to
| none |
