Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    2

    Red face Unanswered: odbc_exec and SQLSTATE=42704

    Hi all !

    I have to use DB2 to test something, and when i want to connect me i have an error :

    Warning: odbc_exec(): SQL error: [IBM][CLI Driver][DB2/NT] SQL0204N Le nom "ROOT2.SCAT" n'est pas défini. SQLSTATE=42704 , SQL state S0002 in SQLExecDirect in c:\appserv\www\***\ins\RWconnect.php on line 184

    My login is root2 and i want to send this query : SELECT type FROM scat WHERE id=1.

    Do you have already seen this error ?
    Thanks for your help !

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    It means there's no table named "SCAT" in the "ROOT2" schema.

  3. #3
    Join Date
    Jun 2006
    Posts
    2
    Yes sorry, i start with db2
    There's no table scad in the root2 schema, there's in the ADMINISTRATEUR schema.

    so : SELECT type FROM ADMINISTRATEUR.scat WHERE id=1
    And it works fine

    Thx

Posting Permissions

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