1.获取包
Error:
unknown driver "mssql" (forgotten import?)"
2.根目录 go install 注册驱动
3.测试代码
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) } } } }