SAP Knowledge Base Article - Preview

2667962 - dbping works, but dbisql connection to database fails - SAP IQ

Symptom

Server is running , ps command shows IQ server process , but when trying to connect to it using dbisql it returns the following error

%dbisql -c "uid=<dba userid>;pwd=<dba password>;eng=sapiqserver;dbn=SAPIQDB" -nogui
Could not connect to the database.
Specified database not found
SQLCODE=-83, ODBC 3 State="08001"

%dbping -c "Server=sapiqserver;DBN=SAPIQDB"
SQL Anywhere Server Ping Utility Version 16.0.0.1359
Ping server successful.

%ps -ef | grep iqsrv
owner    4632      1  0 May22 ?        00:24:20 /software/IQ-16_0/bin64/iqsrv16 -n sapiqserver -gp 4096 -x tcpip{PORT=2639} -gm 1 -iqlm 17066 -iqtc 17066 -iqmc 17066 -c 48m -gc 20 -gd all -gl all -ti 4400 -tl 0 -gn 25 -o /software/IQ-16_0/logfiles/sapiqserver.0002.srvlog -hn 5


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

Sybase ; util ; utility db ; shell ; pid ; catalog , KBA , BC-SYB-IQ , Sybase IQ , How To

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.