|
Creating Text Files with My.Computer.FileSystem.WriteAllText |
|
All Things Tech
|
By host on
12/29/2006 5:50 PM
|
|
|
 Today I was having trouble with a simple text file receiving 3 characters at the beginning of the file. After checking to make sure none of my output strings contained the characters, I started checking the methods use to write the file. Sure enough, I had forgotten to change the default encoding (Encoding.UTF8) to Encoding.ASCII. After changing my method parameters, the file came out clean and ready to use.
Example code:
My.Computer.FileSystem.WriteAllText("c:\myfile.csv", content.ToString, False, System.Text.Encoding.ASCII)
|
 |
|
Comments (0)
|
|
|
|
Saving time during development |
|
All Things Tech
|
By host on
12/28/2006 9:54 AM
|
|
|
|
In September, I knew I had to do something about my development environment. The systems I had in place were causing too much "lag" in my build/test cycles.
During my parts selection for the new development workstation, I chose the Western Digital Raptor 10K RPM drive. Although you pay more for less space, you gain up to 30% in read/write speed. This directly translates into faster build/test cycles.
Here is a chart showing some testing done with the drive:
http://www.barefeats.com/hard38.html
So when considering new systems and their associated cost, also consider the time saved during the project and what that is really worth.
|
|
|
|
Comments (0)
|
|
|
|
SQL Server - User already exists in current database |
|
All Things Tech
|
By host on
12/20/2006 5:42 PM
|
|
|
This is repost from Hugh Mc Gauran's blog that I found useful: Error 15023: User already exists in current database - Easy Fix
After
doing a restore from a SQL Server backup, the users login
rights are removed from the database yet the user itself still remains
in the roles of the database. This means that when you try and add the
user again you get the error "Error 15023: User "albert" already exists
in current database" and the addition fails.(where albert is the user
you wish to add) The quickest way to get this working is using
query analyser and running the following command when working on the
actual database. EXEC sp_dropuser 'albert' This will drop the user from the database and you can then re-add the user through the GUI or through a SQL query!
|
|
|
|
Comments (0)
|
|
|
|
Trillian Profile Copy |
|
All Things Tech
|
By host on
12/20/2006 5:42 PM
|
|
|
This one couldn't be easier.
1. Install Trillian and fire it up the first time.
2. Shut down Trillian.
3. Copy the \Program Files\Trillian\users\default folder to the same spont on the new workstation.
4. Start up Trillian and test.
|
|
|
|
Comments (0)
|
|
|
|
Dell UltraSharp 2007FP |
|
All Things Tech
|
By host on
10/14/2006 4:43 PM
|
|
|
I've been using the Dell 1801FP 18" flat panel (1280x1024) for several
years now and have been completely happy with it. After using the
2007FP 20" flat panel (1600x1200) in a dual monitor configuration for a
day now I have to say WOW! 
I
had read a few reviews in which the panels did not receive glowing
ratings. Thus, I did some looking around to see what options were
available. In the end, I found these flat panels head and shoulders
above the others I looked at in this category: Viewsonic VP2030B,
Samsung 204B, and NEC MultiSync 20WMGX2.
Overall, the panels are
very bright and without any aberations around the edges. With Clear
Type enabled, the fonts are smooth and clean - nice!
Another
great feature is the very thin square edge outside the viewable area.
When dual monitors are butted up to one another, you have only 3cm
between visible desktops. So the illusion of a seemless 3200x1200
desktop almost becomes reality. Sweet!
Each panel comes with a
height adjustable stand as well as the ability to pivot right and
left. Compared to the other adjustable stand panels I looked at, these
are rock solid. Even when I'm pounding out code on the keyboard, the
panels do not move or vibrate.
For US$450 each, I feel that I received a great product at a fair price.
Bottom line, for multi-monitor configurations, I just don't think these panels can be beat.
|
|
|
|
Comments (2)
|
|
|
|
Microsoft Access 2007 - Workgroup Security |
|
All Things Tech
|
By host on
10/12/2006 4:40 PM
|
|
|
I've been developing a large application in Access for a number of years. Today I attempted to open it up in Access 2007 for the first time and got the security warning that I was not a member of the proper workgroup. In the past, you simply selected a menu option and joined the proper workgroup by pointing to your .MDW file. This feature appears to have been removed in '07.
But all is not lost. You can fire up regedit and update the following registry key:
HKCU\Software\Microsoft\Office\12.0\Access\Access Connectivity Engine\Engines\SystemDB
I copied my custom MDW file to the following folder in my profile:
"C:\Documents and Settings\%username%\application data\microsoft\Access"
and changed the registry key to "Application Data\Microsoft\Access\custom.mdw"
Simply restart '07 and open your MDB and you are in business!
|
|
|
|
Comments (0)
|
|
|
|
Installing SQL Server 2005 Express Edition on Windows 2003 Small Business Server |
|
All Things Tech
|
By host on
10/11/2006 10:11 AM
|
|
|
I recently needed to put an instance
of SQL Server 2005 Express Edition on a customers Windows 2003 Small
Business Server in order to support a website I had developed for
them. I was very concerned that it might interfeer with the existing
SQL 2000 MSDE that was installed.
So, I took the time and
built an identical SBS server using VMWare Workstation. From there I
was able to install SQL 2005 Express and test the results. It used the
default settings and let it create its own instance.
After
the install and required restart of the virtual machine, I tested the
systems and all were working normally. I proceeded to do the
installation on the production server and once again had a successful
install with no impact to existing services.
As of today, all services are running perfect and the website is up and running.
|
|
|
|
Comments (1)
|
|
|