odbc_close($conn); ?> $connString = "Driver=PostgreSQL Unicode;Server=localhost;Database=mydb;Uid=postgres;Pwd=password;" $conn = New-Object System.Data.Odbc.OdbcConnection($connString) $conn.Open() $cmd = $conn.CreateCommand() $cmd.CommandText = "SELECT version()" $reader = $cmd.ExecuteReader() while ($reader.Read()) $reader.GetString(0)
conn.Open(); Console.WriteLine("Connected successfully!"); odbc driver for postgresql
$result = odbc_exec($conn, "SELECT * FROM products"); while ($row = odbc_fetch_array($result)) echo $row['name'] . "\n"; odbc_close($conn);