sql server - How to setup project to work with odbc and mssql drivers? -

sql server - How to setup project to work with odbc and mssql drivers? -

i'm trying utilize odbc driver , i'm getting errors:

.\main.go:5: imported , not used: "code.google.com/p/odbc/api" .\main.go:72: undefined: driver .\main.go:76: undefined: driver

i tried work driver: go github.com/denisenkom/go-mssqldb ran unto same type of problem. that's why suspect didn't set environment right unable find issue.

my environment: set goarch=amd64 set gobin= set gochar=6 set goexe=.exe set gohostarch=amd64 set gohostos=windows set goos=windows set gopath=c:\go\projects set gorace= set goroot=c:\go set gotooldir=c:\go\pkg\tool\windows_amd64 set term=dumb set cc=gcc set gogccflags=-g -o2 -m64 -mthreads set cxx=g++ set cgo_enabled=1

i installed odbc using go code.google.com/p/odbc ran test , finished fine: c:\go\projects\src\code.google.com\p\odbc>go test -mssrv=.\sqlexp -v -run=ms ... --- pass: testmssqlutf16toutf8 (0.00 seconds) === run testmssqlexecstoredprocedure --- pass: testmssqlexecstoredprocedure (0.01 seconds) pass ok code.google.com/p/odbc 0.574s

my code: (copied mssql_test.go):

package main import ( "code.google.com/p/odbc/api" "database/sql" "flag" "fmt" "os" "runtime" "testing" "time" ) func mssqlconnect() (db *sql.db, stmtcount int, err error) { ......... homecoming db, db.driver().(*driver).stats.stmtcount, nil } func closedb(t *testing.t, db *sql.db, shouldstmtcount, ignoreifstmtcount int) { s := db.driver().(*driver).stats ......

.\main.go:5: imported , not used: "code.google.com/p/odbc/api" .\main.go:72: undefined: driver .\main.go:76: undefined: driver

delete import

"code.google.com/p/odbc/api"

add import

"code.google.com/p/odbc"

replace *driver *odbc.driver. example,

homecoming db, db.driver().(*odbc.driver).stats.stmtcount, nil

and

s := db.driver().(*odbc.driver).stats ./main.go:5: imported , not used: "github.com/denisenkom/go-mssqldb" mssql

change import to

_ "github.com/denisenkom/go-mssqldb"

for example,

package main import ( "database/sql" _ "github.com/denisenkom/go-mssqldb" ) func main() { conn, err := sql.open("mssql", makeconnstr()) }

the go programming language specification

import declarations

to import bundle solely side-effects (initialization), utilize blank identifier explicit bundle name:

import _ "lib/math"

sql-server go odbc package