zippy1981

[string] $mongoDriverPath;
# Check to see if we are running the 64 bit version of Powershell. 
# See http://stackoverflow.com/questions/2897569/visual-studio-deployment-project-error-when-writing-to-registry
if ([intptr]::size -eq 8) {
    $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.0").'(default)';
}
else {
    $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.0").'(default)';
}

zippy1981

[string] $mongoDriverPath;
# Check to see if we are running the 64 bit version of Powershell. 
# See http://stackoverflow.com/questions/2897569/visual-studio-deployment-project-error-when-writing-to-registry
if ([intptr]::size -eq 8) {
    $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.0").'(default)';
}
else {
    $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.0").'(default)';
}

zippy1981

#Updated at Sun Jun 05 14:55:40 EDT 2011
#Sun Jun 05 14:55:40 EDT 2011
database.password=postgres
database.url=jdbc\:postgresql\://localhost\:5432/myproject
database.username=postgres
database.driverClassName=org.postgresql.Driver

zippy1981

C:\Users\zippy>pathed /machine /remove 27
PATHED - Version 3.2
Freeware written by Gerson Kurz (http://p-nand-q.com)

00 C:\Program Files (x86)\PHP
01 C:\Windows\system32
<snip> . . . . . .</snip>
25 c:\Program Files\MongoDB\mongodb-win32-x86_64-1.8.1\bin
26 c:\Program Files (x86)\GnuWin32\bin
27 c:\Program Files\TortoiseHg

zippy1981

DROP TABLE etr;
GO

CREATE TABLE etr ( 
      col_1 real NOT NULL,
      col_2 real NOT NULL,
      col_3 real NOT NULL,
      col_4 real NOT NULL,
      col_5 real NOT NULL,
      col_6 real NOT NULL,

zippy1981

# Based Loosely on this VB script using a commercial ActiveX object to interrogate the registry.
# http://www.motobit.com/help/regedit/sa117.htm
Get-ChildItem HKLM:\SOFTWARE\Classes\CLSID | ForEach-Object {
	$regKey = $_;
	if ($regKey.GetValue('OLEDB_SERVICES') -ne $null -and $regKey.OpenSubKey("OLE DB Provider") -ne $null) {
		New-Object PSObject -Property @{
			'Key' = $regKey.GetValue("");
			'OLEDBProvider' = $regKey.OpenSubKey("OLE DB Provider").GetValue("");
		};
	}

zippy1981

# Copyright (c) 2011 Justin Dearing <zippy1981@gmail.com>
#
# Permission is hereby granted, free of charge, to any person obtaining a copy
# of this software and associated documentation files (the "Software"), to deal
# in the Software without restriction, including without limitation the rights
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
# copies of the Software, and to permit persons to whom the Software is
# furnished to do so, subject to the following conditions:

# The above copyright notice and this permission notice shall be included in

zippy1981

$cn = New-Object System.Data.SqlClient.SqlConnection 'Data Source=.;Initial Catalog=master;Integrated Security=SSPI;';
$cn.Open();
$cmd = $cn.CreateCommand()
$cmd.CommandText="SELECT * FROM sys.tables"
$rdr = $cmd.ExecuteReader();

$dt = New-Object System.Data.DataTable;
$dt.Load($rdr);

$dt.Rows | Format-Table;

zippy1981

USE master;
GO

IF  EXISTS (SELECT name FROM sys.databases WHERE name = N'dropMe')
DROP DATABASE [dropMe]
GO
CREATE DATABASE dropMe;
GO

DECLARE @fileName VARCHAR(MAX)

zippy1981

*** Assembly Binder Log Entry  (9/23/2011 @ 10:19:11 PM) ***

The operation was successful.
Bind result: hr = 0x0. The operation completed successfully.

Assembly manager loaded from:  C:\Windows\Microsoft.NET\Framework64\v2.0.50727\mscorwks.dll
Running under executable  C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
--- A detailed error log follows. 

=== Pre-bind state information ===