Advertisement
Guest User

Untitled

a guest
Jun 15th, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. package main
  2.  
  3. import (
  4. "database/sql"
  5. "fmt"
  6. _ "github.com/denisenkom/go-mssqldb"
  7. "log"
  8. )
  9.  
  10. var server = "DESKTOP\SQLEXPRESS"
  11. var port = 1433
  12. var user = "loginx"
  13. var password = "1"
  14. var database = "test"
  15.  
  16. var db *sql.DB
  17.  
  18. func main() {
  19. var err error
  20.  
  21. connString := fmt.Sprintf("server=%s;user id=%s;password=%s;port=%d;database=%s;",
  22. server, user, password, port, database)
  23. fmt.Println(server, user, password, database)
  24. conn, err := sql.Open("mssql", connString)
  25. if err != nil {
  26. log.Fatal("Open connection failed:", err.Error())
  27. }
  28. fmt.Printf("Connected!n")
  29. defer conn.Close()
  30.  
  31. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement