isql command for Sybase IQ does not work
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_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?
Stefan Zumbühl replied
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_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?