进行MSSQL连接 [英] Go MSSQL Connection

问题描述

如何提供MSSQL连接?它说它总是与代码联系在一起.即使信息不正确，也不会出错.

How do I provide an MSSQL connection? It says it's always connected with the code. Even if the information is incorrect, it does not give errors.

package main

import (
    "database/sql"
    "fmt"
    _ "github.com/denisenkom/go-mssqldb"
    "log"
)

var server = "DESKTOP\\SQLEXPRESS"
var port = 1433
var user = "loginx"
var password = "1"
var database = "test"

var db *sql.DB

func main() {
    var err error

    connString := fmt.Sprintf("server=%s;user id=%s;password=%s;port=%d;database=%s;",
        server, user, password, port, database)
    fmt.Println(server, user, password, database)
    conn, err := sql.Open("mssql", connString)
    if err != nil {
        log.Fatal("Open connection failed:", err.Error())
    }
    fmt.Printf("Connected!\n")
    defer conn.Close()

}

Open()中的

推荐答案

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()
}

这篇关于进行MSSQL连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！