| Author |
Interactive SQL does not open
|
|
| John Moore 2005-06-22, 7:23 am |
| I have Sybase 6.0.3 running on W2k server. Since this
morning I cannot open Interactive SQL in Sybase Central. It
was working fine until yesterday but now when I right click
a table and go to Open Interactive SQL, nothing happens.
Nothing has changed since then on the server.
If you have any suggestions as to what I can do please let
me know. Since this is a production server, I cannot
restart the server during normal business hours so anything
I can do to avoid it would be helpful.
Thanks in advance.
| |
| Rick Blythe 2005-06-22, 9:23 am |
| Open the tak manager to see if there is a zombie dbisql present. If you see
it on the list, try end-tasking it.
| |
| John Moore 2005-06-22, 9:23 am |
| > Open the tak manager to see if there is a zombie dbisql
> present. If you see it on the list, try end-tasking it.
>
>
Yes I saw dbisql.exe running in Task Manager and ended it.
But it still doesn't come up.
| |
| John Moore 2005-06-22, 9:23 am |
| > > Open the tak manager to see if there is a zombie dbisql
> it. >
> Yes I saw dbisql.exe running in Task Manager and ended it.
> But it still doesn't come up.
I see a task named scjview.exe in Task Manager. Should I
end that too? Hopefully that won't stop any db running on
the server, will it?
| |
| David Kerber 2005-06-22, 9:23 am |
| In article <42b9642b.2032.1681692777@sybase.com>, John Moore says...
>
> I see a task named scjview.exe in Task Manager. Should I
> end that too? Hopefully that won't stop any db running on
> the server, will it?
No, that is SybaseCentral, probably the fast-start stub.
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
| |
| Jeff Albion \(iAnywhere Solutions\) 2005-06-22, 11:23 am |
| Try running from the command-line "dbisql -batch". This will create a file
called "isqlj.bat" in the current directory which references all the Java
components that dbisql requires. Make sure that all of the paths are correct
and the files it references exist.
For a temporary workaround, try using dbisqlc.
--
Jeff Albion
Product Support Analyst
iAnywhere Solutions
<John Moore> wrote in message news:42b962d1.201f.1681692777@sybase.com...
> Yes I saw dbisql.exe running in Task Manager and ended it.
> But it still doesn't come up.
| |
| John Moore 2005-06-22, 11:23 am |
| Thanks. The problem seem to have rectified on its own. I
can open I SQL now normally.
I will try your method it this happens again.
> Try running from the command-line "dbisql -batch". This
> will create a file called "isqlj.bat" in the current
> directory which references all the Java components that
> dbisql requires. Make sure that all of the paths are
> correct and the files it references exist.
>
> For a temporary workaround, try using dbisqlc.
>
> --
> Jeff Albion
> Product Support Analyst
> iAnywhere Solutions
>
> <John Moore> wrote in message
>
>
|
|
|
|