The following are 2 lines that opens a sql connection via the sql .net namespace.  The first line does not work, but the second line does.  The only difference is the () after the Open function.

When I use the VS 2005 IDE, I believe this is optional, but apparently in PowerShell, this is not.  I've done some simple programming, but I don't understand the significance of the parenthesis.  Can somebody let me know or link me some info?  Thanks!

DOES NOT WORK!
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection "server=myserver;database=database1;Integrated Security=sspi"
$SqlConnection.Open

WORKS!
$sqlConnection = new-object System.Data.SqlClient.SqlConnection "server=myserver;database=database1;Integrated Security=sspi"
$sqlConnection.Open()

I can't swear to it but I think the significance is that you are calling a function and the empty parenthesis indicate you are calling it without any arguments.

I hope you find this post helpful.  

Regards,

Mark

Check out my scripting solutions at http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER.  The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier!  Save time, get more work done, get the Admin Script Pack.