Go - connect remote SQL server
refer from: https://studygolang.com/articles/19117 package sqlsvr import ( "fmt" "database/sql" "strings" "wms.api/model" _ "github.com/denisenkom/go-mssqldb" _ "github.com/mattn/go-adodb" ) type Mssql struct { *sql.DB dataSource string database string windows bool sa SA } type SA struct { user string passwd string } func (m *Mssql) Open() (err error ) { var conf [] string conf = append(conf, "Provider=SQLOLEDB" ) conf = append(conf, "Data Source=" +m.dataSource) if m.windows { // Integrated Security=SSPI :以当前WINDOWS系统用户身去登录SQL SERVER服务器(需要在安装sqlserver时候设置), // 如果SQL SERVER服务器不支持这种方式登录时,就会出错。 conf = ...

Comments
Post a Comment