且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

进行MSSQL连接

更新时间:2023-02-22 16:28:30

mssql应该为sqlserver

尝试更改此内容.

db, err = sql.Open("sqlserver", connString)

所以您的main()看起来像..

So your main() would look like..

var db *sql.DB

func main() {
    var err error

    // Create connection string
    connString := fmt.Sprintf("server=%s;user id=%s;password=%s;port=%d",
        server, user, password, port)

    // Create connection pool
    db, err = sql.Open("sqlserver", connString)
    if err != nil {
        log.Fatal("Error creating connection pool: " + err.Error())
    }
    log.Printf("Connected!\n")

    // Close the database connection pool after program executes
    defer db.Close()
}