Error received:

please run sandisk secureaccess from a sandisk external device

just unplug, plug into a diff port and try again. Seems to work. I learned it from the last post here.

So the code in theory is super slick – just use a StringWriter and HtmlWriter and in 2-5 commands it is downloaded to the client (see this link and the caveats that people use to get things working!). NO SUCH LUCK HERE. The main reason is that I have 2 columns with buttons in them at the front – the whole grid is DYNAMICALLY created by myself in the code (that is not included below). The c# code is included below.

So using some other researching I found a couple of concepts that worked together. I am sure there are some other optimizations but this worked.

First, I converted the GridView contents to a DataTable and for all columns 3 or more columns over I filled the datatable. Thanks to this fellow. Because the Gridview has all the source info including column headers etc. it works out great. Continue reading →

Some articles as i collect them are:

• Actually referencing and making diff. levels work together
  • same recommendation as the link above (w. 433 upvotes) – useLegacyV2RuntimeActivationPolicy
  • and again but with a little more if you scroll down (I see a pattern here)
  • a few good links exist with this article as to what useLegacyV2RuntimeActivationPolicy does
    • msdn article on  <startup useLegacyV2RuntimeActivationPolicy…>
    • why it was done
• Background on CLR (major release and side-by-side) vs. upgrade to a CLR (inplace upgrade)

Putting HTML in bulleted lists seems quite straightforward until you try it. The items only accept text and html is rendered as text so you don’t get the html – you SEE the html. OK – so some digging turned up the following useful links. These are good for the same items but I need dynamic html different in one item than the other so I am doing it with html and a div or something.

These links will no doubt prove useful for repeating items that are the same.

• General Discussion telling you what control to use and when
• Using SQL as a datasource (which is what I am doing anyways)
• Good article for more than just repeaters – Five ASP.NET Controls You Might Be Craving

Google had informed them “recently received a notification from Google stating that our website has unnatural links pointing towards [zoho]. This has really damaged our Keyword rankings on Google …” and to remove the links. It was my recent article on a topic about them and some links to them that solved – what should be quite simple but it is QUITE HARD actually and I had been victorious.

Here is an article to help with a redirect that made me clear up Google crawling errors.

What? No – I am not going to remove any links! This is a website is all about STORING LINKS for myself and others reading this. Continue reading →

Optimizing these large tables DOES NOT WORK. It corrupts them and you have to talk to tech support to get backups restored. Even when you ssh into the server and do it “command line.” I reminded myself of this yesterday when I optimized a table forgetting the better way.

First, back up the sluggish table. It had lots of overhead – this is a hint. Another way to back it up, is to copy it to a new table. Here’s how (don’t do this from phpmyadmin because it will for sure time out). I use a mac so I have sequel_pro AND SET THE TIMEOUT  TO 1000 seconds or more in the preferences. If you have access to ssh into the machine – even better.

[sql]</pre>
CREATE TABLE xxx_backupddd_nnn LIKE xxx;
insert into xxx_backupddd_nnn SELECT * FROM xxx;

RENAME TABLE xxx TO xxx_overheadddd_nnn;
CREATE TABLE xxx LIKE xxx_overheadddd_nnn;
INSERT into xxx SELECT * FROM xxx_backupddd_nnn;
<pre>

[/sql]

In my case xxx is the table and ddd_nnn the date and attempt such as 20140303_1.  I run each command line by line and carefully look at the output. Sometimes the server times out even after 1/2 seconds so be watchful.

No tech support phone call or $15 backup recovery fee required. Really – that is not bad for a recovery fee.

So I have had LOTS of attempts to get into a password protected MS 2010 Access database and most people online say it cannot be done (the advice in many google’ed articles) , however one guy gave me the hint to get this solved for me in “Answer 4”.

Scenario:

1. I am connected to SSMS on domain #1 called F which is a SQL Server on Domain D
2. MS Access file is on Domain D on the c drive c:\Temp\dB123.accdb (this c: drive is the one where the SQL Server is running)
3. In SSMS, I made a new Linked Server using the GUI Continue reading →

I need to zip files and add a timestamp to the zip filename, or I don’t have a backup system (I just have a copy of the latest files whether or not they are correct). This is TOTALLY related to my article on scripting out my SQL table data contents. This is run as a scheduled task – but I had to take a copy of the solution on my LOCAL drive- not a network copy or else the scheduled tasks does not work. See my article to reduce frustrations on Scheduled Tasks.

Using c# – here is the code snibbet (read the whole article though) Continue reading →