sqlconnect

Cancel Edit [WikiEntry.PreviewButtonText] Save
Summary: A simple example script for creating a connection to a SQL Database.

function sqlConnect (string$connString)
{ 
		   $sqlConn = new-object [System.Data.SqlClient.SqlConnection;] 
		   [$sqlConn.ConnectionString] = $connString; 
		   $sqlConn.Open(); 
		   $sqlConn.Close();
}

Example: MSH> sqlConnect "Data Source=SSTSQL;Integrated Security=SSPI;Initial Catalog=BBTK"
Cancel Edit [WikiEntry.PreviewButtonText] Save
Microsoft Communities