如何使用GO连接到Linux中的MSSQL数据库

Question

I have created and connected to an sql server on linux using this tutorial.

I am using golang and this driver. (https://github.com/denisenkom/go-mssqldb)

I am having problems connecting to the database using golang. I have specified a user as SA and a password. I have also written in the terminal "hostname" and got the hostname xxx. When I use that info to connect I get a 500 error.

conn, err := sql.Open("mssql", "server=xxx; id=SA; password=mypass; database=testdb)

Does this seem correct? I am a newbie so maybe I am missing something obvious?

Answer 1

In the Github example you can see how it work. You can follow those steps:

var (
    server    string = "localhost" // for example
    user      string = "userdb"    // Database user
    password  string = "userpwd"   // User Password
    port      int    = 1433        // Database port
)

connString := fmt.Sprintf("server=%s;user id=%s;password=%s;port=%d", server, user, password, port)
conn, err := sql.Open("mssql", connString)

// Test if the connection is OK or not
if err != nil {
    panic("Cannot connect to database")
} else {
    fmt.Println("Connected!")

  }
// Don't forget to close the connection to your database
defer conn.Close()