Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Unanswered: ODBC Connection errors

    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

  2. #2
    Join Date
    Jan 2004
    Posts
    3
    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

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Your feedback is much appreciated!!!

    Thanks

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •