Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

isql command for Sybase IQ does not work

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

replied

Hi Vivek

Thanks for your input.

With the "dbisql ....-nogui" its possible to connect on commandline.

I'm still trying to connect with the command "isql". In addition I have done the following later:

I have installed the ASE SDK 15.7 client. And then I created the interfaces file.

But i have still the same error:

CT-LIBRARY error:

        ct_connect(): directory service layer: internal directory control layer error: Invalid syntax found in interfaces file.

I will create a batch file for running backups. This one i will start over the crontab.

What ist the best way to do this?

Regards Stefan

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question