package main
import (
"database/sql"
"fmt"
_ "github.com/alexbrainman/odbc"
)
func main() {
connStr := fmt.Sprintf("driver={SQL Server};SERVER=192.168.1.1;UID=sa;PWD=db123;DATABASE=DBOne")
conn, error := sql.Open("odbc", connStr)
if error != nil {
}
defer conn.Close()
stmt, err := conn.Prepare(`select [key] from [sys_config]`)
if err != nil {
fmt.Println(err.Error())
}
defer stmt.Close()
rows, err2 := stmt.Query()
if err2 != nil {
fmt.Println(err2.Error())
}
if rows != nil {
//fmt.Println(rows.RowsAffected())
for rows.Next() {
var key string
if err := rows.Scan(&key); err == nil {
fmt.Println(key)
}
}
}
}