链接sqlserver2008

require (
    github.com/denisenkom/go-mssqldb v0.0.0-20200620013148-b91950f658ec
    github.com/go-ole/go-ole v1.2.4 // indirect
    github.com/mattn/go-adodb v0.0.1 // indirect
    golang.org/x/net v0.0.0-20200707034311-ab3426394381 // indirect
)

package main

import (
    "database/sql"
    "fmt"
    "log"

    _ "github.com/denisenkom/go-mssqldb"
)

// var (
//     debug         = flag.Bool("debug", true, "enable debugging")
//     password      = flag.String("password", "123456", "the database password")
//     port     *int = flag.Int("port", 1433, "the database port")
//     server        = flag.String("server", "10.10.10.53", "the database server")
//     user          = flag.String("user", "sa", "the database user")
// )

func main() {
    // var debug = flag.Bool("debug", false, "enable debugging")
    // var password = flag.String("password", "123456", "the database password")
    // var port *int = flag.Int("port", 1433, "the database port")
    // var server = flag.String("server", "10.10.10.53", "the database server")
    // var user = flag.String("user", "sa", "the database user")
    // var database = flag.String("database", "ed", "the database name")

    // if *debug {
    //     fmt.Printf(" password:%s\n", *password)
    //     fmt.Printf(" port:%d\n", *port)
    //     fmt.Printf(" server:%s\n", *server)
    //     fmt.Printf(" user:%s\n", *user)
    // }
    connString := fmt.Sprintf("server=%s;database=%s;user id=%s;password=%s;port=%d;encrypt=disable", "10.10.10.53", "ed", "sa", "123456", 1433)

    fmt.Printf(" connString:%s\n", connString)

    db, err := sql.Open("mssql", connString)
    if err != nil {
        log.Fatal("Open connection failed:", err.Error())
        return
    }

    err = db.Ping()
    if err != nil {
        fmt.Print("PING:%s", err)
        return
    }
    fmt.Println(1)
}