Using Golang to connect MSSQL under Windows

This is a creation in Article, where the information may have evolved or changed.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Directory (?) [+]

1. Install the Microsoft SQL Server Native Client
2. Installing Golang's MSSQL Drive
3. Write test code

I wipe, recently down dozens of g of data (haha, you understand), are the MSSQL format, need to deal with. Want to use Golang processing, so you need Golang connection MSSQL.

1. Install the Microsoft SQL Server Native Client

Go to the official download, download the address:

[Plain]View Plain copy print?

1. http://www.microsoft.com/zh-CN/download/details.aspx?id=35580

http://www.microsoft.com/zh-CN/download/details.aspx?id=35580

2. Install the Golang MSSQL Drive

Go get CODE.GOOGLE.COM/P/ODBC

3. Write the Test code:

[Plain]View Plain copy print?

2. Package Main
6. Import (
8. _ "Code.google.com/p/odbc"
10. "Database/sql"
12. "FMT"
14. )
18. Func Main () {
20. Conn, err: = SQL. Open ("ODBC", "Driver={sql server};server=192.168.1.1;port=1433;uid=sa;pwd=password;database=test")
24. If err! = Nil {
26. Fmt. PRINTLN ("Connecting Error")
28. Return
30. }
32. Defer Conn. Close ()
34. stmt, ERR: = conn. Prepare ("Select Top 5 ID from Users_role")
36. If err! = Nil {
38. Fmt. Println ("Query Error", err)
40. Return
42. }
44. Defer stmt. Close ()
46. Row, err: = stmt. Query ()
48. If err! = Nil {
50. Fmt. Println ("Query Error", err)
52. Return
54. }
56. Defer row. Close ()
58. For row. Next () {
60. var ID int
62. If err: = row. Scan (&id); Err = = Nil {
64. Fmt. PRINTLN (ID)
66. }
68. }
70. Fmt. Printf ("%s\n", "Finish")
72. Return
74. }