SSMS 2012 Error

QuentinSQuentinS Posts: 3
edited October 3, 2012 8:00AM in SQL Search Previous Versions
Hi,

I recently installed SQL Server 2012 and have started using SSMS 2012 for all my development. I reinstalled SQL Search 1.1.6.1 but whenever I start SQL Search and whenever I type something in the search box it comes up with an error message from the web browser control that displays the ads -

Cannot find ...:/Users/Q/AppData/Local/Red%2520Gate/SQLSearch%25201/Ads/3.mht?e98e50.... etc
Make sure the path or Internet address is correct.


That path does exist. I thought it might be a permissions issue so I gave that Ads folder full permissions for Everyone.
No joy.

It looks like it's inserting an extra 25 after the %.
If I paste it into a browser it says the same thing (not found) but if I remove the 25 after the % (and just have %20) it works.

Any help would be appreciated because it is making SQL Search virtually unusable.

Comments

  • QuentinS -- I just had the same problem and was able to resolve it.

    I had moved my User folders to my E: drive. I looked at my C: drive and found the Red Gate folder there. I then copied it to my E: drive and it looks like all is well. At least, I don't get the error.

    I don't know if you have the same situation, but it looks like the install program doesn't ask Windows for the User folder location, but the app does.
  • My AppData is in the usual place.
    The issue is that the SQL Search HTML control that shows the ads is treating the URL space (%20) as a literal part of the address and converting the % to a URL % (%25) -

    /Red Gate/SQLSearch 1/Ads/...

    should get converted to

    /Red%20Gate/SQLSearch%201/Ads/...

    but it's getting converted to this -

    /Red%2520Gate/SQLSearch%25201/Ads/...

    It looks like it's getting converted twice and the second time it treats the converted URL as an unconverted URL.
    I'm wondering if it's a .Net thing. I've got .Net 4.5 beta installed.

    Anyone? Bueller?
  • greg_burnsgreg_burns Posts: 10 Bronze 2
    I just ran into this error myself today. I am also running SSMS 2012.

    I had also just installed VS 2012 RC...
  • I am seeing this as well only with ssms 2012 ssms 2008 works fine still. I also have vs 2012rc installed
  • Clean machine, clean install of VS 2012 RC, SQL Server 2012 and SQL Search 1.1.6.1 and I run into the same issue. My user directory is D:\Curt and the managled name is missing the drive letter and has the spaces URL encoded twice. It does make the product rather annoying to use. 1.5 months after initial report and no fix. They are usually better than this.
  • We believe the issue to be caused by .NET Framework 4.5.
    Unfortunately .NET Framework 4.5 is not currently supported.
    I have notified development of the issue and it has been assigned the internal reference number of SDI-515.
    Manfred Castro
    Product Support
    Red Gate Software
  • dmullen99dmullen99 Posts: 1 Bronze 1
    Wow, a month goes by with no update? On my system SQL Search is not functional at all with that error popping up with every keystroke. Redgate, there's supporting .net 4.5 and being able to co-exist with it.

    It took me all of 5 minutes to figure out the root problem and a workaround. It'd be nice if someone at Redgate could take a few minutes and do the same but whatever. It appears to me to be caused by the path being double encoded as %25 is "%" so encoding the space made a %20, encoding that made a %2520

    If anyone else has this problem, I was able to get around it by making a copy of the AppData\Local\Red Gate directory and calling it Red%20Gate. Then, inside that directory rename the SQLSearch 1 directory to SQLSearch%201. Might be an issue with the other directories in there as well but I haven't noticed anything (yet.) Hope that helps...
  • I fequently use and recommend Red-Gate SQL Search. It is now broken with the error in the title.

    Previous posts link this to .NET 4.5 . .NET 4.5 and VS 2012 are now production. My expectation is that a first tier tool company supports released tools.

    When does Red-Gate intend to update its tool set to support released MS development tools?
  • My thanks to dmullen99. Implemented the work around discussed and am able to now use Search.
  • MCTSQLMCTSQL Posts: 14 Bronze 3
    Ditto on the thanks to dmullen99 !!! :D
    MCTSQL
  • dmullen99 wrote:
    Wow, a month goes by with no update? On my system SQL Search is not functional at all with that error popping up with every keystroke. Redgate, there's supporting .net 4.5 and being able to co-exist with it.

    It took me all of 5 minutes to figure out the root problem and a workaround. It'd be nice if someone at Redgate could take a few minutes and do the same but whatever. It appears to me to be caused by the path being double encoded as %25 is "%" so encoding the space made a %20, encoding that made a %2520

    If anyone else has this problem, I was able to get around it by making a copy of the AppData\Local\Red Gate directory and calling it Red%20Gate. Then, inside that directory rename the SQLSearch 1 directory to SQLSearch%201. Might be an issue with the other directories in there as well but I haven't noticed anything (yet.) Hope that helps...

    The workaround above did not work for me, so I used a sledgehammer to fix it as I was still getting errors regarding the advert .mht files being missing.

    So once Sql Search is installed on your SQL 2012 environment copy the

    \AppData\Local\Red Gate

    folder in your username directory, and make a folder at

    \AppData\Local\Red%20Gate with all of the contents within.

    Then make another copy of the same folder at

    \AppData\Local\Red%2520Gate

    Try using the search a few times and let it keep erroring (just OK them), it will generate 5 files:

    1.mht
    2.mht
    3.mht
    4.mht
    Default.mht

    in \AppData\Local\Red Gate\SQLSearch 1\Ads

    copy these files to both Ads folders in the copied folders you created above.

    The \AppData\Local\Red%20Gate folder may not be needed but I didn't have the time to check. 10 minutes messing around is enough :) Hope this helps.
  • I forgot to add don't forget to change the directory names for SQLSearch 1 directory to SQLSearch%201 and SQLSearch%25201 respectively. Cheers.
  • I'm also experiencing this after installing VS2012. However, since my user login has spaces in it none of the workarounds are viable. Any news on fixing this issue?
  • Thanks dmullen99 your solution worked perfectly. I'm in SQL 2012 .Net 4.5
  • We've just released an updated version of SQL Search (1.1.8.20) that should play nice with .NET 4.5 - you can download it from the product page here:

    http://www.red-gate.com/products/sql-de ... ql-search/

    In addition, SQL Search now shares a toolbar with SQL Source Control and SQL Test if you've got those installed.
    Andy Campbell Smith

    Red Gate Technical Support Engineer
Sign In or Register to comment.