SAP Knowledge Base Article - Preview

3156521 - Creation of the IQ demo database has failed with "Database server not found"

Symptom

  • The IQ demo database creation script has failed due to an error Database server not found.
  • dbisql cannot connect to the utility database by using the same connection parameters as well.
    But, the utility database was running.

    mkiqdemo.sh -dba dba -pwd Sap123

    This script will create the iqdemo database in the current directory.  
    An existing iqdemo database in this directory will need to be shutdown and over-written.
    Continue <Y/N>? y

    Checking system ...
    There are no servers running on this system
    Starting Server ...
    Starting server bld_demo_9708 on Hostname at port 9708 (03/02 10:01:22)
    << omission >>
    I. 03/02 10:01:25.060189 Starting on port 9708
        SharedMemory link started successfully
    Trying to start TCPIP link ...
    Starting on port 9708
        TCPIP link started successfully
    I. 03/02 10:01:30.064048     TCPIP link started successfully
    I. 03/02 10:01:30.065672 Now accepting requests
    Now accepting requests
    New process id is 8065
    Server started successfully
    Started.
    Connecting to server via TCPIP ...
    Using: uid=DBA;pwd=sql123;eng=bld_demo_9708;dbn=utility_db;links=tcpip{host=Hostname;port=9708}
    Creating database ... Error at line 1
    Database server not found

  • dbisql

    dbisql -c "uid=DBA;pwd=sql123;eng=bld_demo_9708;dbn=utility_db;links=tcpip{host=Hostname;port=9708}" -nogui

    Could not connect to the database.
    Database server not found
    SQLCODE=-100, ODBC 3 State="08001"


Read more...

Environment

SAP IQ all version

Keywords

IQdemo, iqdemo, iqdemodb, create, build,  , KBA , BC-SYB-IQ , Sybase IQ , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.