Activity overview
Latest activity by JamesPlaistere
I forgot to add don't forget to change the directory names for SQLSearch 1 directory to SQLSearch%201 and SQLSearch%25201 respectively. Cheers. / comments
I forgot to add don't forget to change the directory names for SQLSearch 1 directory to SQLSearch%201 and SQLSearch%25201 respectively. Cheers.
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 [image] Hope this helps. / comments
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...