Techniana

PowerShell, Scripts and Cmd.exe

2010-08-19T11:54:00.000-07:00

PowerShell's designers don't seem to be overly concerned about including intuitiveness as a feature. Consider what it takes to run a PowerShell script from the cmd.exe prompt. Bet

c:\> Powershell blah blah

doesn't do what you would think it would do. PowerShell expects "blah blah" to be code written in Powershell. the canonical example is the following:

c:\> Powershell 2+2
4

Get it? Do you ever find yourself typing "Powershell blah blah" at the command line? I didn't think so. PowerShell is a scripting language, so you might be expecting

c:\> Powershell script.ps1

to run a script named script.ps1. Well if so, you would be wrong. PowerShell instead expects "script.ps1" to be a PowerShell command, which it obviously isn't. The solution, for some unexplained reason, is to add an ampersand in quotation marks. Thus,

c:\> Powershell "&" script.ps1

BTW, it's more conventional to put the script reference in quotation marks as well. In other words,

> Powershell "& script.ps1"

According to the error message you receive if you type

c:\> Powershell "& blah blah"

the quoted ampersand tells PowerShell that what comes afterward is one of four things:

cmdlet
function
script file
operable program

Apparently, this error message is the only official instruction from Microsoft regarding the ampersand switch.

Changing .NET App Properties/Settings at Runtime

2010-07-23T11:59:00.000-07:00

Visual Studio* provides an application settings (aka properties) feature for console, library or windows applications. Creating and editing application settings at design time is straight-forward and can be managed conveniently thru VS's GUI.

But what if you need to change the settings at run-time? The answer is anything but obvious. The settings are contained in a class called "Settings," which derives from System.Configuration.ApplicationSettingsBase. You could of course rewrite the code in the settings class, but then if you decide to make a change in VS's GUI all of your handiwork is immediately hosed.

There's one adjustment you can make directly in the GUI that puts you a step closer to your goal. At the top of the Settings Designer screen, is a drop down box titled "Accessor Modifier." There are two choices: the default is "Internal." The other choice is "Public." Choose "Public." As we'll see, this one alteration allows us to change the value of the properties in our code.

The application expects there to be a static property called Default, of type Settings, in the class Settings. Default, the only instance of Settings that will be acknowledged by the app, is created for you automatically by VS. Default is essentially functioning as a singleton. Finally, ApplicationSettingsBase provides an indexer allowing us to reference the individual settings on Default.

Here's an example:

MyApp.Properties.Settings.Default["MyProperty"] = value;

ORA-12154 TNS:could not resolve the connect identifier specified

2010-01-26T11:09:00.000-08:00

Hey Oracle enthusiasts. Here's a fun one. I encounter this just about whenever I try to configure, unsuccessfully, TNSNames.ora for ODP.NET. Recently, I decided stopped worrying about TNS and put everything into the connection string, like so:

Data Source=(DESCRIPTION= (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=LOCALHOST)(PORT=1521))) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME = orcl))); USER ID=whatever;PASSWORD=********;"

This works every time.

It just seems as though TNS isn't worth the trouble.

Backing Up Oracle, Easily

2009-12-16T11:57:00.000-08:00

As a developer I have a need to replicate environments. As I now work regularly with Oracle, my environment-maintenance duties should include duplicating Oracle databases across various machines. But how in the world do you do that?

It's been a real eye-opener to research what's involved with Oracle administration. I've come to the conclusion that the Oracle company doesn't really bother itself with things like quickstarts. Sadly, all their documentation is written in documentation-ese. What a struggle.

A few days ago I broke down and tackled the Oracle restoration challenge. I finally restored my first Oracle database today, and I thought I'd document how to do it, for the benefit of others. Essentially, I copied files over from the old server to the new one. FYI, this is what as known as a "cold" backup and recovery because the databases are shutdown when the activity occurs.

1. First, run these commands in sqlplus or Sql Developer to find out which files need to be copied:
          select name from v$datafile; -- this provides the datafiles
          select name from v$controlfile; --this provides the control files
2. Note the redo files. They are in the same directory as the datafiles.
3. Now log into the database to be replicated as sysdba
          $>sqlplus "/ as sysdba"
4. And issue the "shutdown abort" command
5. Similarly on the new server, issue the "shutdown abort" command
5. Copy all the files referred to in items 1, 2, and 3 above from the server to be replicated to the corresponding locations on the new server
6. Back in sqlplus on the server to be replicated, issue the "restart" command
7. Do the same for the new server

Congratulations! You should be up and running on the new server by now.

Google, My Friend

2009-10-28T14:23:00.000-07:00

It's astonishing to me how well Google distinguishes itself in anticipating its customers' needs. I couldn't remember the file name for the Task Manager program. I only knew that it was some abbreviation of TaskManager.

I tried doing a search on "task manager command line" or something like that receiving nothing but frustration. But then remembering Google's "Did you mean . . .?" feature. I typed "cmd tskmngr" into Google's search box. There it was.

Did you mean: cmd taskmgr

Simple. Effortless.

How Again Do You Get Data Out of a Refcursor in Sql Developer?

2009-10-28T14:06:00.000-07:00

There appears to be no way for me to memorize how to run a stored procedure in Sql Developer that uses a refcursor. So I'm putting an example here. That way I can refer to it any time I want.

variable CV_1 REFCURSOR;
declare V_INTUSERID number;
BEGIN
V_INTUSERID := 1;
spProc1(V_INTUSERID,:CV_1);
END;
PRINT CV_1;

Visual Studio Shortcut for Using Directives

2009-10-07T08:29:00.000-07:00

My current vote for top Visual Studio shortcut goes to "Shift-Alt-F10." This little beauty will bring up the "Options to help bind the selected item" dialog which will allow you to command the UI to inject the appropriate "Using" directive at the top of a class. Trying to bring up this dialog with the mouse is tricky and time-consuming. Save those precious brain cells for something else.

"Add Reference" Dialog Delays

2009-10-07T08:07:00.000-07:00

Today I decided to reduce the impact of an annoying problem with Visual Studio--the length of time it takes to initially bring up the "Add Reference" dialog. It can take a minute! I run into this delay constantly because I seem to almost always need to add a reference to System.Configuration to every project. My approach was to create a custom project template with the reference already included. Here are the steps I took:

Navigate to "C:\program files\microsoft visual studio 9.0\common7\IDE\ProjectTemplates\CSharp\Windows\1033"
Copied the template ConsoleApplication.zip
Navigate to My Documents\Visual Studio 2008\Templates\ProjectTemplates\Visual C#
Pasted ConsoleApplication.zip
Opened up the zip with "Open with > Compressed (zipped) folders" and dragged "consoleapplication.csproj" onto the desktop
At line 45 added

    <Reference Include="System.Configuration" />       

Saved the proj file
Opened up the zip with Winzip (or use 7zip) and dragged in the new version of "consoleapplication.csproj"
Closed winzip (or 7zip)

The new project template is ready to use!

The official documentation from Microsoft is here.

Executing Console Commands with PowerShell

2009-10-06T13:26:00.000-07:00

I'm just starting to master PowerShell . . and I emphasize the word "starting". Frankly, I'm disappointed with the learning curve required. PowerShell doesn't seem to be optimized, yet, for quick learning, despite that it piggy-backs off of .NET.

Here's a tip. Don't throw away those useful scraps of "DOS" commands you've been carrying around for many years. You can reuse them inside of PowerShell. Here's an example:

 cmd /c  <PathToCommand> arg0 arg1 argEtc

Getting Started with the 7Zip Command Line

2009-10-06T12:51:00.000-07:00

7Zip's command line tool has umpty-um options. Many of them are very useful. But if you are looking only for a command line version of the Windows' "Send to > Compressed (zipped) Folder" command, then you can get by with merely the following:

 7z a -tzip <ZippedFileName>.zip <FolderName>

Using C Sample Code in MSDN

2009-10-01T08:18:00.000-07:00

Here's a simple tip for Windows C (and C++) programmers. There's a wealth of C code samples in MSDN. Unfortunately, many of those I've seen and used suffer from the same deficiency: they not unicode friendly and therefore not compatible with recent versions of Visual Studio. It's relatively easy to fix, however. Substitute the _tmain function for main and for _tmain's second parameter use "_TCHAR* argv[]" instead of "char *argv[]."

GOTO May Be Considered Helpful

2009-09-16T12:47:00.000-07:00

As it turns out, at least one legitimate use exists for the notorious GOTO statement: breaking out of nested loops. Knowing from first-hand experience the problems that could be caused by "goto programming", I hadn't written a goto in 25 years. Recently, however, when trying to a write function with nested loops, it dawned on me that the most elegant solution would indeed involve a goto, at least when using C#. In fact, Microsoft's C# reference guide specifically recommends using a "goto" when exiting an inner loop, I later found out. (Maybe I ought to be reading Microsoft's online docs more often.)

In reviewing Steve McConnell's Code Complete (Second Edition), as I always do when confronting fundamental coding challenges, I was surprised to find only the vaguest of advice regarding "goto"--never say never, use your head, etc. Earlier in his book, McConnell does mention a Java-only approach. Java, which doesn't implement goto, actually has the nifty solution of named blocks, allowing you to end a break statement with the name of a block. I think this is superior than using a goto, but Java seems to be the only language with this feature.

Another author I consulted in this regard was Jeff Atwood. Atwood also describes beneficial situations for using goto, but in the only in the context of an "early return," rather than as a solution specifically for exiting nested loops. On the other hand, I really like Atwood's description of "return" and "exit" as being merely tightly scoped goto's.

Loading Image Resources

2009-09-10T11:57:00.000-07:00

Here's sample code to load an image resource file, which works even if the resource file is not in the executable assembly, but in a referenced assembly.

Bitmap bmp = new Bitmap(
    System.Reflection.Assembly.GetAssembly(typeof(pick_a_class)).
    GetManifestResourceStream("Dll.Path.Image.jpg"));

pick_a_class is the name of any class in the relevant assembly.

The resource name may not be obvious. Here's code to determine the exact names of the various resources:

string[] all = System.Reflection.Assembly.GetAssembly(typeof(pick_a_class)).
    GetManifestResourceNames();

Manipulating Xml with C#

2009-09-08T12:54:00.000-07:00

I'm pretty fond of the XDocument class. XDocument lets you have your way with XML without requiring convoluted syntax, especially when used in conjunction with lambda expressions. Here's an example to change the value of an attribute on nodes that were found through a search criterion.

XDocument xDoc = XDocument.Load(
    new StringReader(
        @"<Customers><Customer ID=""99"" Description=""Just another customer""></Customer></Customers>"));
xDoc.Descendants("Customer").ToList().
    ForEach
    (e =>
        {
            if (e.Attribute("ID").Value == "99")
            { e.Attribute("Description").Value = "Our best customer"; }
        }
    );

Hiding ASP.NET Configuration Files from VSS

2009-06-10T11:25:00.000-07:00

All I wanted to do was to keep a few ASP.NET web site files from being versioned by Visual Sourcesafe. Seemed like a reasonable request. I'm talking about deployment specific configuration files with things like server names in them that are referenced in web.config using the configSource attribute. This approach is necessary for real world scenarios, where, for instance, a production server would not know what to do with the name of a database which is located only on my dev box. Unfortunately neither Visual Studio (current version 2008) nor VSS knows how to ignore any ASP.NET files.

I wonder what does everyone else does? I've met few ASP.NET developers who actually know about the configSource attribute. And I suspect that the few that do probably struggle originally as I have with an occasional mishap and then turn to batch scripts like as I have done for many months now.

There must be a better way, I mumbled to myself this morning. So a-Googlin' I went. Through a quick search, I've encountered several blog posts suggesting a hack on the vssscc file for the solution. Suppposedly you can add a line like "EXCLUDED_FILE0" = "filename" and reset the "NUMBER_OF_EXCLUDED_FILES" line. There's only one catch; it doesn't work. There went 30 minutes down the drain.

After more extensive searching, I was able to find an awkward but workable solution, from a post on a slightly different topic, which is to set the machine specific files as "hidden" in Windows. Never used that feature of Windows before! Never had a need to.

There you are. Easy, right. Yeah, it's easy all right, once you know. Hard if you don't know. I can't decide: Is it surprising that productivity insights are about the hardest thing in software development to Google for, or is really not surprising at all? After all, internet "knowledge" seems to be mostly the blind-leading-the-blind.

It took me months to buckle-down and hunt for a solution to this annoying problem. I'm really glad I finally got around to it. I certainly hope, however, that in the future my futility-o-meter becomes more sensitive and I don't wait as long when I run into productivity snags.

Sorry. We Get the Support Documentation We Deserve

2009-05-30T09:02:00.000-07:00

We programmers love to mumble to ourselves in abject silence about how poorly a commercial framework, api, server app, etc is documented. Though such complaints might be understandable, I suspect that the lack of effective documentation is many instances at least partly a function of apathy on the part of the user base.

Recently, I ran into perhaps the vauguest and cryptic Oracle error messages of all time: "ORA-01461 can bind a LONG value only for insert into a LONG column."

Huh? LONG? LONG is a defunct data type. Hey Oracle, what I really need to know is which column? And which table? And what exactly is meant by a "LONG value?" It's just a string characters.

Eventually I figured out that the offending insert statement referred to a column that was varchar2(4000 characters). But my string only had 2020 characters. So I should be good. Right?

Turns out Oracle has a built-in global limitation of 4000 bytes, not characters, for a varchar2. See http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/datatype.htm#CNCPT01. Even if you specify 4000 characters, the 4000 byte limit overrides. Depending on the encoding a character can be and usually is greater than one byte. Characters are typically 2 bytes. So my 2020-character string actually occupies 4040 bytes. Thus, my insert was over the global limit.

But why does the error message use the term LONG? The LONG data type can be up to 2 gigabytes. Evidently, this error message dates back to yesteryear when the only way to upload a character string longer than 4000 bytes to a table was to use a LONG column. Today, you can use a bunch of different LOB data types, instead of LONG.

Here's what really burns me: Googling "ORA-01461" provided no answers. Hmmm. What's up with that, my fellow Oracle programmers? Okay, so Oracle is not connecting the error message with the likely context in which you would see error message. Yes, that sucks. But what about our responsibilities? I haven't run across anyone on the interwebs complaining about how utterly lame and useless this error message is. If we don't complain with specificity and articulation, don't expect old-line software vendors such as Oracle to give a hoot.

Variables in Sql Developer

2009-05-14T12:15:00.000-07:00

Ever find yourself having to remember how to to use variables in Oracle's handy tool Sql Developer? Me, I can never remember. That's why this post is here.

There are two types of variables in the Oracle world: substitution variables and bind variables. It's important to remember that you can't use substitution variables in Sql Developer, but you can use bind variables. The syntax for bind variables is the following:

variable custno number

exec : custno := 99

Select * from customer where customerId = : custno;

Now I'll remember.

.Net Code Converters

2009-04-23T14:11:00.001-07:00

Once in a while I find a useful code sample written in VB.Net. Today I needed some code that essentially does the work of OracleCommandBuilder.DeriveParameters, but with some modifications. I found a code sample for just such a class, posted by someone named David Browne at http://www.dotnetmonster.com/Uwe/Forum.aspx/dotnet-ado-net/116/Returning-Stored-Procedure-Parameters. Unfortunately, Mr. Browne's code is in VB.Net, whereas I'm in the middle of writing an app in my preferred language, C#.

The best code converter I've found thus far is from Telerik at http://converter.telerik.com. What's key about this converter is that it gives you very helpful translation error reporting for the inevitable copy-and-paste glitches that accompany any sizeable snippet gleaned from the web, such as inappropriate link breaks.

Edit and Continue vs. Lambda Expressions

2009-01-03T16:46:00.000-08:00

Microsoft giveth and Microsoft taketh away. One of the amazing gifts of .Net 3.5 is lambda expressions. Once you start using them, it's hard to stop. Unfortunately, lambda expressions are not compatible with another innovation: Visual Studio's Edit and Continue (or EnC). If you try to edit code with lambda expression while debugging in VS you get the following:

"Modifying a 'method' which contains a lambda expression will prevent the debug session from continuing while Edit and Continue is enabled."

According to this post, EnC is also incompatible with anonymous methods, a limitation present since .Net 2.

Data Dude Has Trouble Diffing Views, Stored Procedures, and Functions

2008-08-15T14:13:00.000-07:00

Data Dude's schema compare feature is a technical wonderment . . . when it works. It seems to be fine when comparing databases to each other. Unfortunately, when comparing a data dude "project" to a database created independently from Data Dude, Data Dude seems think that there is extra whitespace in its cached copy of the ddl for the database's view, function and stored procedure ddl. What's going on here? It turns out that Data Dude is very picky about what is considers properly written ddl definitions. Data Dude wants you to allow it to write all the ddl to the database! Thus if you have created your database objects in SQL Server Management Studio you'll have to resync going from the Data Dude project back to the database after importing the schema from the database--a full round trip. You should be careful about backing up, as always.

It's a shame such a great tool has such a lame bug.

Note: Data Dude is the nickname for the Microsoft project formally known as Visual Studio Team System 2008 Database Edition.

Adding a File to a Setup Project in Visual Studio

2008-07-30T13:45:00.000-07:00

I've had serious installer trouble after adding a C# project's content file to a Visual Studio Setup project. Try as I might, each time I tried to use a content-file output from another project I got a failed install. Repeated attempts to install gave me an erroneous error saying the service was already installed. This was because the failed install left an orphaned registry entry. Wonderful. I had to use "sc delete" to get rid the registry entry.

Lesson learned: just right click on the installer and select "add file." I referenced a file in the other project in this manner and the installer project created a relative reference. Should do the trick.

The reason for adding a content file to the install was to allow a perl script to be executed by the application.

SharePoint UI Madness

2008-07-30T10:31:00.000-07:00

For most user-level activities, SharePoint's UI has typically been adequate. The administrative features, however, continue to sport UI problems that are world class. Someday I'll get around to making a list of my absolute most hated UI blunders in SharePoint. I think it would be best to wait for a day when I'm already in a bad mood because some of these problems seriously perturb me.

Today I had to deal with one that really got me going: adding and editing user accounts for a SharePoint site. You would think that the link to that functionality would just jump out at you once you navigate to site admin (called "settings" in SharePoint-speak) . Nope. The appropriate link appears exclusively in the left sidebar of the "people" page for your site. First navigate to the settings page of your site by using the "Site Actions" dropdown in the upper right hand corner of the page. Then click on "People and Group" link under the "User and Permissions" list. On the ensuing page, People.aspx, look to the left nav for the bolded words "All People." Once you click this link, you'll see all the "people." Thus, in getting to this page, to do something really basic, we've gone through three different navigation schemes!

Below is a screen shot showing the "All People" link.

Parsing Command Line Parameters in VC++

2007-08-15T12:05:00.000-07:00

One of the most confounding things in the C/C++ programming world is the unnaturalness of C-style "strings." I put quotation marks around "strings," because when you're C-stylin', your dealing actually with arrays of chars, not string-like objects. Chances are if you're coding in C++ what you really want are STL strings, not arrays of chars. This confusing situation is a much bigger problem for novices than old hands, but in either case it's still a bit awkward. Unless you're also using .NET (CLI), arrays of chars are unavoidable when parsing command line parameters--a feature that most sophisticated applications require.

If you're using VC++ (versions VC++2003, VC++2005, or VC++2008) as your IDE, your "main" function, which is actually "t_main" in VC++, confronts you not with char* but _TCHAR*, making things even more cryptic. (The "t" and "T" characters refer to the configurability of VC++2008 to handle unicode or not, depending whether the _UNICODE is defined at compilation. But you knew that.) I'm really puzzled about not yet seeing a book author take on this common chore. You could have a pretty annoying Google-session trying get sample code to parse command line parameters with this version of the main function.

Most Google group queries I found on this topic tend to focus on conversion functions. Though I almost always love a clever, succinct function to do my dirty work, in this case I may pass, because it only takes a few lines of memorable code to slip the chars into a handy vector of strings. In this case, we use wstring (for "wide string") instead of string. The do-while below adds a de-referenced pointer to wchar_t (the "wide" version of char)

wstring a_wstring;
do a_wstring += *argv[i];
while(*argv[i]++);

The key thing to realize is that wstring knows what do with char's.

Here's a short program that stores the parameters in a vector and also displays them to the

#include "stdafx.h"
#include
#include
#include
using namespace std;

int _tmain(int argc, _TCHAR* argv[])
{
vector args;
for(int i =0;i<argc;i++)
{
wstring a_wstring;
do a_wstring += *argv[i];
while(*argv[i]++);
args.push_back(a_wstring);
cout << i<<"\n";
wcout << args[i] << "\n";
}
return 0;
}

You should be able to do just about whatever you want with the parameters after putting them into a vector of wstrings.