Cannot go install github.com/denisenkom/go-mssqldb@latest?

[sheeeng]

I'm following the instructions from Microsoft's documentation.

$ go version                                           
go version go1.16.3 darwin/amd64
$
$ go install -v github.com/denisenkom/go-mssqldb@latest

go install: package github.com/denisenkom/go-mssqldb is not a main package

Did I miss anything?

See also denisenkom/go-mssqldb#649.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 44fb6283-7b17-7ae4-5ad4-bf5bb5702e7f
• Version Independent ID: f19e7d27-dce2-c34b-a666-a8ed2862c087
• Content: Use Go to query - Azure SQL Database & SQL Managed Instance
• Content Source: articles/azure-sql/database/connect-query-go.md
• Service: sql-database
• Sub-service: development
• GitHub Login: @David-Engel
• Microsoft Alias: sstein

[Oury-MSFT]

@sheeeng We are looking into this and will get back to you

[Oury-MSFT]

@sheeeng We tried to reproduce the issue and got the same error message.
@David-Engel Could you please suggest a workaround. I have also seen here that Go1.16 is broken. Could you also help confirm that.

[Oury-MSFT]

Faced the same issue when creating go install -v github.com/denisenkom/go-mssqldb@latest

[David-Engel]

@sheeeng @Oury-MSFT
Go has definitely changed. I believe the go install command is no longer necessary. Can you try continuing on with the sample, skipping the go install github.com/denisenkom/go-mssqldb command and confirm that it still works for you?

[Oury-MSFT]

@David-Engel I have tried the code without the go install but I got this error message highlighted in yellow.

[David-Engel]

I have tried the code without the go install but I got this error message highlighted in yellow.

@Oury-MSFT Your screenshot shows you are not running the right commands from the article. From the SqlServerSample folder (after the cd SqlServerSample command), you should only have to run:

go get github.com/denisenkom/go-mssqldb

Note: It won't produce any output.
After that, you create your sample.go file and then simply run:

go run sample.go

[sheeeng]

It works with go get and go run by skipping go install.
Should we update the documentation before closing this issue?

[Oury-MSFT]

@David-Engel It works for me as well.

[David-Engel]

I'll submit a PR and close this issue once it's merged.

[David-Engel]

Doc updated. It should be reflected after the next scheduled publish.

#please-close