Logging into ISQL

[DanAuber]

At the moment everytime I login to ISQL I have to click on the ISQL icon and then complete a load of fields (User ID, PAssword, COnnection Name,Database name,database file,server and startline)

Surely there must be a way to have all of these (except possibly ID and password) already coded in (via a script file ?)

Can someone explain how I can do this ?

ta

Dan

Dan Auber
DanAuber@aol.com

http://members.aol.com/_ht_a/danauber/myhomepage/

 

[Starg]

Which version of ISQL are you using? I use "Sybase Adaptive Server Anywhere ISQL Version 6.0.3.3066" and there is an option to use an ODBC driver as input for all the parameters you mention. It is possible to also script it, checkout the reference guide for full details but for an example here is the command I use in a batch file.

"C:\Sybase\Adaptive Server IQ 12\win32\dbisql.exe" -c "uid=data_read;pwd=daer_atad;CommLinks=tcpip(host=bass_dw:5009);dbn=dw_data;ENG=bass_dw_dw_data"

You could also look at using a third party ISQL product. Embarcadero have a product called "Universal ISQL".

Hope that helps.

Starg