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")
}
This https://code.google.com/p/odbc/ driver works with MS SQL Server for me.
Alex
I encountered this same issue not too long ago and after two days of researching I was able to fix the issue.
The confusing aspect seems to come from the fact that the go-mssqldb needs a parameter passed named "server" and in SQL Management Studio they have a clear reference to server in the connection properties:
However, this is not the value go-mssqldb is looking for. It is looking for the actual server where the DB is installed. Meaning, if it is installed in your local PC this would be "localhost". If it's on another machine in your network, then this would be the corresponding IP address or server name
Another thing to keep in mind is that go-mssqldb needs a port to connect to the DB and if you don't provide one, it assumes the port is 1433. However, mine wasn't that value. In order to look for your port number:
SQL Server Configuration Manager
Finally, the command I ended up using to run my code ended up being:
sqlserver-agent -debug=true -server=localhost -port=62587 -user=Username -password=Password -database=DatabaseName