Old People will recognize that version and build as one of The Greats, still functioning in many parts of the world. Young People, of course, will remain clueless :)
At some recent point, possibly after a Microsoft update to Windows 7, isql.exe stopped working when it comes time to open the GUI editor window on a database that it has (most probably) connected to (if it can't connect, it does display the GUI messages to that effect; see later).
WAGs are welcome, even ones that repeat what I've already tried and described below :)
The symptom is this: isql.exe just sits there in the DOS box...
The engine dbsrv50.exe starts OK on the local machine or another computer, and the client dbclient.exe starts OK on the local Win 7 machine.
If I don't have dbclient.exe running, isql.exe displays the following dialog boxes which indicates that it is PARTLY working (and an isql.exe entry exists in Task Manager)...
The symptoms are the same when the engine is running locally or on another computer; it can (probably) connect but not display the editor GUI.
Nothing shows up in the Event Viewer.
Turning off the firewall doesn't help.
Everything works OK when everything is run on Windows XP... and it USED TO WORK OK on Windows 7.
Using Run As Administrator does not help.
The yellow UAC warning dialog box does appear every time isql.exe is launched, regardless of whether or not Run As Administrator was used.
Turning off UAC does suppress the warning, but doesn't fix the problem.
Futzing around with isql.exe properties did not help; e.g., Take Ownership, Troubleshoot Compatibility, Run this program in compatibility mode for: Windows 95, stuff like that.
I can move all my V5 work to the XP computer so this isn't a showstopper, but any WAG that lets me work on one desktop would be most welcome!
Batch file to start server on XP computer...
SET SQLANY=C:\Program Files\Sybase\SQL Anywhere 5.0 "%SQLANY%\win32\dbsrv50.exe" -n ddd5 -o dbsrv50_ddd5_log.txt -x tcpip ddd5.db
Batch file to start dbclient on Win 7 computer...
"%SQLANY%\win32\dbclient.exe" ddd5 -x tcpip
Batch file to start isql on Win 7 computer...
"%SQLANY%\win32\isql.exe" -c "dbn=ddd5;eng=ddd5;uid=dba;pwd=sql"