I am trying to connect to sql server express using go and this sql driver "github.com/denisenkom/go-mssqldb"
Currently it calls open then stalls on the ping command, it never pings or returns an error.
I am using winauth and it works with sql management studio.
I have verified the database name, if I put a false one in, an error is generated and logged at the open step.
I have tried setting a really short connection time out but the same thing happens.
I have tried connecting to a remote sql server and it works correctly. The remote server is a developer version of sql server and had a name like xyz.abc.123 where my local sql express is called machine-name\sqlexpress.
Here is a sample program.
package main
import (
"database/sql"
_ "github.com/denisenkom/go-mssqldb"
"log"
)
func main() {
log.Println("Main:")
log.Println("Opening")
db, err := sql.Open("mssql", "server=Machine-Name\\SQLEXPRESS; database=MyDatabaseName;")
if err != nil {
log.Println("Open Failed: ", err.Error())
}
log.Println("Opened")
log.Println("Pinging")
err = db.Ping();
if err != nil {
log.Println("Failed to ping: ", err.Error())
}
log.Println("Pinged")
}