I have a database server (dbsrv16.exe) which is running as a windows service. I can see the service running from Sybase central also. But when I am trying to do an isql -S<server name=""> it is throwing me an error saying ""ct_connect(): directory service layer; internal directory control layer error: Requested server not found."
NOTE: I tried pinging the server and the database with dbping and its pinging successfully. I can also find the server name in dsedit.
EDITED: Tried with dbisql and UID=DBA;PWD=sql and it worked. However when I am trying to issue a dbstop on the same server it is showing that the requested server is not found.
Please let me know how or what file/s should I check to resolve this issue.
You are using the ISQL utility that comes as part of the SDK for ASE. The native SQL Anywhere Interactive SQL utility is dbisql.
OpenClient CT-ISQL looks up the servername in an "Interfaces" (see -I) file where that servername needs to have been added so the client (ISQL) can find the correct network address and port information there. If your intention was not to use tools meant to connect to ASE (Replication Server or a number of different Open Server based products) then you may want to switch to the native SQL Anywhere Interactive SQL utility
To continue to use CT-ISQL there will be a couple of adjustments needed when connecting to a SQL Anywhere database server. The database server doe need to be started with TCP/IP listener(s) (true by default for dbsrv16) and the entries in your interfaces file must meet a few requirements:
This is TDS based communications and that protocol does not provide features to help you be port and ip agile from the client side. This is one of the native features that dbisql will provide you so you may want to revisit my first statements.
answered 13 Jan, 09:54
Nick Elson S...
The -S option is for some other product, not SQL Anywhere.
Try -c "ENG=ddd16;DBN=ddd16;UID=dba;PWD=sql;"
answered 13 Jan, 07:59