isql remote connection ?

[Former Member]

Hello how to start an isql  remote connection to ASE server ? Regards Eric MOUREY

[Former Member]

Hello I'd like to find the way, to write a remote connection to SAP ASE database from a an application server to the SAP ASE Server: isql -Usapsa -S -"command to remote server" Regards

[ryan_hansen]

Hi Eric,

Do you mean run a command from isql without having to go through the prompt?

You could create a text file:
notepad send.txt

Edit the file with example-

select @@version

go

Then run the command:

isql -Uusername -Ppassword -Shost:port -isend.txt -oback.txt

This will run the command to ASE and send back the results in the file back.txt

Regards,

Ryan

[dawn_kim]

Hi,

From the command line if you do isql -v and it lists 15.xxx or higher you can log into the ASE by doing this: isql -Uyourusername -Sipaddressoftheboxthathoststhease:port#ofASE

Then you should get a popup for your password.
From there you should be able to do sql commands.

isql ref: SyBooks Online

Thanks,
Dawn Kim