Post reply

Uninstall of 2005 beta2--ISQLW lost sytax highlighting

  • March 25, 2005 at 8:32 am

    #163083

    On my dev box, i had SQL7 installed as a default instance, and SQL2K as a named instance.

    I installed SQL2005 as another named instance, and all three instances were happy as a clam while coexisting.

    I uninstalled SQL2005 several months later, and Query Analyzer has lost it's syntax highlighting capabilities; no keywords appear  in color any longer;

    I reapplied 2K Service pack 3a several times, but that did not fix the issue; I also copied the \Program Files\Microsoft SQL Server\80\Tools\Binn (which contains ISQLW.exe) from one machine to my dev machine, but that did not fix the syntax highlighting issue either;

    From within the ISQL's Tools>>Options>>Fonts, the selections are correct..keywords are supposed to be blue, etc. I've clicked the restore defaults button there as well as making new changes, but that had no effect.

    Searched the MS KB for ISQLW Syntax highlighting with no results....

    any suggestions as to where the sytax highlighting might be disabled?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 25, 2005 at 10:00 am

    #548974

    Found it myself;

    Query Analyzer uses the dll sqllex.dll for the definitions of keywords.

    i did the old regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqllex.dll"

    and it fixed the issue; hope that helps someone else in the future.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 20, 2006 at 4:34 pm

    #627758

    Almost one year later...same problem...yours is the only post on the issue I found. Thanks! Worked like a charm.

  • March 20, 2006 at 6:03 pm

    #627770

    perfect; that's why i love the forums here; somewhere, sometime, someone must have fixed a problem someone else is going to get;

    way to go!

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 21, 2011 at 10:45 am

    #1424369

    That worked! Even on 64 bit Windows 7! Yay, my colors are back!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply