isql command for Sybase IQ does not work

[#1]

Hi all

I have installed the Sybase IQ 16.0 SP8 on a linux SLES environment.

Now itry to create the backups for the database.

I can connect with dbisql without any problems.

The connneciton string is like this:

dbisql -c "uid=dba;pwd=<password>;eng=tss126;dbn=SAPIQDB"

If i try to connect with isql igot always this error message:

CT-LIBRARY error:

        ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.

The connection string that I use is like this:

isql -X -S TSS126 -D SAPIQDB -U DBA -P sql

Here are the information from the SAP Control Center for this DB:

Can someone help me?

Regards Stefan

[tayeb_hadjou]

Hi Stefan,

Have you configured IQ server enrty in interfaces (Unix) or sql.ini (in Windows) file?

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc30056.1604/doc/html/san1282692606704...

Regards,

Tayeb.

[SybDBA]

Hi Tayeb,

Please explain me the difference between isql & dbisql, as it is given here:

[iqug] Difference between isql &amp;amp; dbisql

but I am unable to understand the stuff they have related to the loading or whatever else.

--

Regards.

Vivek

[tayeb_hadjou]

The utility dbisql is recommended with IQ or Sql Anwyhere database, especially for DBA tasks, Loads, etc. It uses odbc or jdbc, and nativelly uses Watcom Sql language.

dbisql can work in GUI (default) or in interactive (option -nogui).

Isql is a utility based on Open Client libraries and intially designed for SAP Sybase ASE (Adaptive server Enterprise), but compatible with IQ and Sql Anywhere.

An example where DBAs perefer isql instead of dbisql, is execution of Transact sql scripts).

Connection to IQ with open client isql, will implictly set, via login procedure, options for Transact Sql compatibility, like Ansinull, Quoted_identifier, Chained, etc.

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00801.1604/doc/html/san1281565042320...