Results 1 to 7 of 7

Thread: unixodbc

  1. #1
    Join Date
    May 2007
    Posts
    7

    Unanswered: unixodbc

    hello, i need you help
    i have two pc on the network
    1.PC - db2 server with databace "CENTRALA"

    2. PC is client with unix odbc , i am using db2_v9_linux_db2driver_for_odbc_cli as driver for unix odbc

    slavo@bedna:~$ cat /etc/odbc.ini
    [CENTRALA]
    Driver=DB2
    Description=DB2
    Database=CENTRALA

    slavo@bedna:~$ cat /etc/odbcinst.ini
    [DB2]
    Description = ODBC for DB2
    Driver = /opt/ibm/db2/V9.1/lib32/libdb2.so
    FileUsage = 1
    DontDLClose = 1

    but connection does not work, when i test it from DataManager (included in unixodbc), i always get error code " [08001][unixODBC][IBM][CLI Driver] SQL1013N The database alias name or database name "CENTRALA" could not be found. SQLSTATE=42705"

    thak you

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    it looks like there is something wrong with ODBC connection.

    1. ucatalog odbc connection:
    Code:
    db2 uncatalog system odbc data source centrala
    2. Create ODBC connection:
    Code:
    db2 catalog system odbc data source centrala
    P.S. I have tested this on Windows box, because I don't have access to Unix box.
    Hope this helps,
    Grofaty
    Last edited by grofaty; 05-23-07 at 07:38.

  3. #3
    Join Date
    May 2007
    Posts
    7

    thanks but ...

    this command returns this
    SQL1297N This command is currently not supported on this platform.

  4. #4
    Join Date
    May 2007
    Posts
    7
    how can i set server hostname or ip ?

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Can you connect from the DB2 command line processor?

    Try cataloging the database first:

    db2 catalog tcpip node myserver remote <server ip or hostname> server <DB2 port number>
    db2 catalog database centrala at node myserver
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    May 2007
    Posts
    7

    :)

    in the client i dont have db2 command ... but on the server connection works locally
    sorry i am new to db2, maybe i dont understand what you mean ...
    and on the 2.pc i have only unixodbc with cli driver , there is no db2cc or somethik like this ...
    but when i want add odbc sources in windows xp i must add it first to db2cc
    Last edited by levin7; 05-24-07 at 04:36.

  7. #7
    Join Date
    May 2007
    Posts
    7
    it works! thank for your help

Posting Permissions

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