在Go Lang中连接到SQL Server 2014

Question

I had a working database connection on a windows 7 machine to SQL Server 2008 R2 using:

     db, err = sqlx.Open("lodbc", connString)

importing the following packages

     "github.com/LukeMauldin/lodbc"
     "github.com/jmoiron/sqlx"

But now using the same driver and changing the connection string to a 2014 SQL Server database located on a remote windows 8 machine, I get a successful connection but a sqlx query breaks saying

datasource 2015/03/23 09:09:37 http: panic serving 127.0.0.1:49346: {IM002} [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Is there another driver I can use? I tried code.google.com/p/odbc and database/mssql packages and those didn't work.

Thanks

Answer 1

Try database/sql with the github.com/denisenkom/go-mssqldb driver.