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'.
SQLConnect: Failed...
No connection could be established.
SQLSTATE = S1000
NATIVE ERROR = 80
MSG =

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?

Thanks,
Harv

I discovered that the issue was a typo in the "odbc.ini" file. Thanks to everyone that had a look at this thread. This issue is resolved.

Harv

Your feedback is much appreciated!!!

Thanks

Sathyaram