My God!
This took hours to figure out. Here is the solution to using ODBC and ASP to connect
to a MySQL database.
1. Install the latest MySQL engine. I believe it is currently 4.1.9
2. Install the MySQL Admin and MySQL Query Browsers - these are just helpful - not essential.
3. Install MyODBC-Standard-3.51.9-win.msi (or exe) Note this is NOT the latest version. The latest version doesn’t work.
4. In MySQL Admin, connect to your database and make sure that “Use Old Passwords is checked.”
5. Follow the instructions here:
Open the MySQL commandline utility (located in MySQL Admin and elsewhere) and type:
mysql> USE mysql
mysql> UPDATE user SET Password = OLD_PASSWORD(’mypass’)
-> WHERE Host = ‘localhost’ AND User = ‘root’;
mysql> FLUSH PRIVILEGES;
SOURCE: http://mysqld.active-venture.com/Old_client.html
That’s it. It should work.
According to Digg’s blog, they’ve just released a blog widget that allows you to show the number of diggs a current story has received.
This will be a great tool to increase the number of diggs your story can receive. It looks fairly easy to implement as well:
-Digg Story Button
Once your story has been successfully submitted you can now display the number of diggs and allow users to digg your content directly by using the…
Matt Cutts just wrote a post recently on Google adopting NOODP meta tag. It specifies that the SERPs (search result pages) shouldn’t use the description from your Open Directory Project listing (ODP for short, located at dmoz.org). MSN already supports this feature.
Having a listing in the ODP helps tremendously in getting traffic to your site from the directory itself as well as increased traffic from the search engines. If you have a high quality site, I suggest you submit it for approval.
This tag is great though. I hadn’t thought of it, but - what if the editor writes a description of your site that you don’t like? What if your description is several years old? Without this tag and feature, you’d have to be content with the search engines describing your site using the data from the ODP.
Good feature.
Related Posts:
Ever since I titled the site, I’ve been looking for a real “Keyboard Face”. This looks like it!
