Archive for July, 2006

Windows XP Recovery Console – Help I forgot the Administrator Password!

Monday, July 10th, 2006

This lovely bootable CD or Floppy tool offers you the option of either resetting the administrator password or simply making the Windows XP Recovery Console just not require an administrator log in. It truly saved my crappy windows computer!

Background:
Gosh, I had a botched Ubuntu install and I was trying to recover from this Grub Error 17. And all the websites told me I needed to fix my master boot record so windows could once again start. They told me to boot from the Windows XP installation CD, and go into the recovery console, however the recovery console kept asking for my administrator password. I don’t know what the heck that is. I installed this thing 3 years ago, and I don’t think I ever logged in as administrator!

I was so grateful when Offline NT Password & Registry Editor above worked, phew! I logged into the recovery console from the Windows XP installation CD, and proudly typed fixmbr, and in less than a second I had my crappy windows back!

Fixing the MySQL “no index defined” Error Message

Sunday, July 9th, 2006

MySQL kept giving me this message whenever I tried to apply a certain foreign key constraint. It turns out that the problem was that the foreign key I was trying to reference wasn’t the same size and data type as the field I was trying to link it on. So that’s what you have to fix.

Here’s where I got that answer. It also has general information on doing referential constraints on the InnoDB type of databases.

When is the MSSQL Server Version of QuickBooks Being Released

Thursday, July 6th, 2006

It’s not, NEVER! I suppose it was just a rumor this whole time. I just came across this in the QB forums. It’s a shame because the QuickBooks API is just so slow and cumbersome.

I honestly do not know where the rumour that we are doing a MSSQL Server version of QuickBooks keeps coming from — we’re not. Any plans we may or may not have regarding a database change would not be discussed in public — Intuit does not pre-announce product…

Even if we WERE to do a SQL-based database the SDK would remain the same (and you would not have ODBC access to the DB) because we would want the freedom to change DB schemas without breaking 3rd party applications. You would be best served sticking with the SDK or a layer built on top of it (like qODBC) that lets you focus on your program logic.

————————-
Peter A. Vogel
Developer Support Manager | IDN PM Lead
Staff SW Engineer
Intuit Developer Network

I read this here.

[tags]QuickBooks, QuickBooks API, API, MSSQL Server, QuickBooks Schema, QuickBooks Database[/tags]

I/O Error Handling in Python

Wednesday, July 5th, 2006

Here’s the code I use to do something with a file in Python and catch any errors. It’s probably basic for most people but I’m always forgetting to use it so I figure I’ll post it here:

try:
	myfile=file('greg.txt','r')
except IOError, error:
	print 'IOError: Could not open:',str(error)
except OSError, error:
	print 'OSError: Could not open:',str(error)

Feel free to suggest improvements! I’ve also always wondered if I could get a list of all the potential error values somewhere.

Stuck at “Acquiring Network Address” – A Simple Potential Fix

Saturday, July 1st, 2006

So I’m trying to connect a Windows XP laptop to a wireless network. It says my connection strength is excellent but it just keeps saying “acquiring network address” when I hover the mouse over that network connection link.

Anyway, what I reccomend you try first is simply to re-enter your password/phrase wherever it was you entered it. The thing I learned is that the router won’t tell you if you have the wrong password, so it will just hang and make you think you have a serious problem.

If that doesn’t solve your problem, here are some more serious looking resources you may try:
How to troubleshoot wireless network connections in Windows XP
How to troubleshoot TCP/IP connectivity with Windows XP
Wireless Networking Improvements in Windows XP Service Pack 2
http://www.practicallynetworked.com/support/troubleshoot_index.htm