I want to connect a MSSQL
database, in python I get connecting to this database but in Go
I can not.
When I exec this code I receive this error:
2017/08/04 12:25:39 Select failed:Login error: EOF
why?
Code:
package main
import (
"database/sql"
"flag"
"fmt"
"log"
_ "github.com/denisenkom/go-mssqldb"
)
var (
debug = flag.Bool("debug", false, "enable debugging")
password = flag.String("password", "********", "the database password")
port *int = flag.Int("port", 1433, "the database port")
server = flag.String("server", "sql2008v\\2k8", "the database server")
user = flag.String("user", "usuario", "the database user")
)
func main() {
flag.Parse()
if *debug {
fmt.Printf(" password:%s
", *password)
fmt.Printf(" port:%d
", *port)
fmt.Printf(" server:%s
", *server)
fmt.Printf(" user:%s
", *user)
}
connString := fmt.Sprintf("server=%s;user id=%s;password=%s;port=%d", *server, *user, *password, *port)
if *debug {
fmt.Printf(" connString:%s
", connString)
}
conn, err := sql.Open("mssql", connString)
if err != nil {
log.Fatal("Open connection failed:", err.Error())
}
defer conn.Close()
rows, err := conn.Query("SELECT TOP (1000) * FROM [jiradb].[jiraschema].[jiraissue]")
if err != nil {
log.Fatal("Select failed:", err.Error())
}
defer rows.Close()
fmt.Printf("bye
")
}