pClass.psm1
class Pgres { static $mesg1 = 'Terminating. Connection Error.' static $mesg2 = 'Error Processing Query.' static [string] MakeConnString ( [string] $Server, [int32] $Port, [string] $Database, [string] $Driver, [PSCredential] $Credential ) { $user = $Credential.UserName $pswd = $Credential.GetNetworkCredential().Password $ConnString = ( "Driver=$Driver; Server=$Server; Port=$Port; Database=$Database; Uid=$user; Pwd=$pswd;" ) Return $ConnString } static [string] MakeConnString ( [string] $Server, [int32] $Port, [string] $Database, [string] $Driver, [string] $User, [string] $Pswd ) { $ConnString = ( "Driver=$Driver; Server=$Server; Port=$Port; Database=$Database; Uid=$user; Pwd=$Pswd;" ) Return $ConnString } } |