start-odbc.ps1 423 B

12345678910111213
  1. Function Start-ODBC([string]$query) {
  2. . .\resources\get-database_password
  3. $conn = New-Object System.Data.Odbc.OdbcConnection
  4. $conn.ConnectionString = "DSN=fusionpbx;username=fusionpbx;password=$database_password"
  5. $conn.open()
  6. if ($conn.State -eq "Open") {
  7. $cmd = New-object System.Data.Odbc.OdbcCommand($query,$conn)
  8. $cmd.ExecuteScalar()
  9. $conn.Close()
  10. }
  11. }
  12. #Start-ODBC "select username from v_users"