Tuesday, October 12, 2010

Success!!

Solved part of the mystery with Visual Studio 2010 and Sql Server Express 2008 r2. Turns out VS 2010 comes with sql server express 2008 untilities and as such, relys on that to create database items within the VS2010 IDE. So if you install SQL Server Express 2008 r2 (as of today) you will lose the function to create database items under the VS2010 IDE.

And if you already have a full version SQL Express older than r2 then you need to run the installation as an "upgrade" otherwise you're going to mess up all version of SQL and the VS2010 IDE won't even be able to connect to a database. So running the "upgrade" fix my problems and allows my VS2010 apps to connect to database created under Sql Server Express 2008 r2. The VS2010 IDE also let me create new databases but not from the Add, NEW Item menu. I could only create a new database under the IDE from the Data Connection tool bar. Go figure. There still needs to be some sort of service pack from Microsoft to fix the bugs. But at least it works now! :-)

Friday, October 8, 2010

Never Again!

For any programmers out there that think installing Microsoft SQL Server 2008 r2 expression edition on a Windows 7 machine with Visual Studio 2010 is a good idea, you are very wrong!!

DO NOT INSTALL SQL server 2008 r2 express on a Windows 7 computer running Visual Studio 2010 unless you want to ruin any SQL database functionality and or spend hour troubleshooting and uninstalling r2 via over 2 dozen manual registery entries before you can get rid of it! OH my goodness, never again!! At least not until Microsoft releases service pack.....3 for it! :-)

Thursday, October 7, 2010

Neat Links 10-7-10

Neat Links:

PDF Search Engine: http://www.pdf-search-engine.com/ This site lets you search the web for .pdf files. This is really handy! I use it to find product manuals and research papers on a wide variety of subjects.

Design a robot online: http://www.mos.org/robot/robot.html This is a cute little site that lets you test your skill at building a robot. See if you add the correct parts to build a robot for the task given. A neat site for kids and adults. Check it out.

If you are like me, you often forget what the color codes of resistors are. This is a great graphic to help you remember what the color strips means: