I’m using DB2 7.2.4 on AIX 5.1 to set up the OLAP Server and OLAP Integration Server. I’m trying to setup my datasources using “odbcconfig”. I can see the changes in “odbc.ini”, but when I try to test the new datasource in “odbcconfig”, I get the error:
testDSN: connecting data source 'SAMPLE' as user 'udbi1'.
No connection could be established.
SQLSTATE = S1000
NATIVE ERROR = 80
When I try to use the OLAP Integration Server Desktop on my PC, I can see the database I’m looking for in the drop down box, but when I try to connect, I get a dialog box with “Error 2003000: ODBC error”.
Can anyone tell we what’s wrong with my environment on AIX, or how to get ODBC working on that box?