mldeveloper01 · March 8, 2021 07:16 · Apr 22, 2013 · Apr 22, 2013 · Apr 22, 2013 · Apr 22, 2013
diff --git a/odbc_setup_macos.md b/odbc_setup_macos.md
@@ -2,9 +2,9 @@ Since I spent essentially two full days figuring out how to access a corporate M
 
 These instructions and the commands that follow, were executed on a MAC OS 10.8.3 system. Additionally, I found this blog [post][1] especially helpful during the debugging process. 
 
-On mac os, there is a default ODBC manager, iODBC. Other Unix based systems tend to use [unixODBC][2]. Look elsewhere for a discussion about the differences between these diver manager. The only feature we care about is being able to connect to SQL databases through [pyodbc][3], and at the time of this writing, the pyodbc requires iODBC as its manager. 
+On mac os, there is a default ODBC manager, iODBC. Other Unix based systems tend to use [unixODBC][2]. Look elsewhere for a discussion about the differences between these driver managers. The only feature we care about is being able to connect to SQL databases through [pyodbc][3], and at the time of this writing [pyodbc][3] requires iODBC as its manager. 
 
-Start by installing freeTDS libraries. FreeTDS allows unix programs to talk natively to MS SQL and SyBase databases.
+Start by installing freeTDS libraries. FreeTDS allows unix programs to talk natively with MS SQL and SyBase databases.
 
     brew intsall freetds
 
@@ -34,7 +34,7 @@ The driver is setup, so now install pyodbc:
 Now try to hit your DB:
 
     import pyodbc as p
-    blah = p.connect("DSN=mysql01;UID=username;PWD=password")
+    conn = p.connect("DSN=mysql01;UID=username;PWD=password")
 
 Should resolve without a problem. See pyodbc [docs][3] for help with executing queries, etc. 
 

diff --git a/odbc_setup_macos.md b/odbc_setup_macos.md
@@ -18,7 +18,25 @@ Under **# A typical Microsoft server** you'll see *host*, *port*, and *tds versi
     port = 1433
     tds version = 7.2 (for MS SQL 2008)
 
-asdfasdf
+Create `~/Library/ODBC/odbc.ini` and fill out the file like so:
+
+    [MyDB]
+    Description = Company MS SQL
+    TDS_Version = 7.2
+    Driver = /usr/local/lib/libtdsodbc.so
+    Server = *********
+    Port = 1433
+
+The driver is setup, so now install pyodbc: 
+
+    sudo pip install pyodbc
+
+Now try to hit your DB:
+
+    import pyodbc as p
+    blah = p.connect("DSN=mysql01;UID=username;PWD=password")
+
+Should resolve without a problem. See pyodbc [docs][3] for help with executing queries, etc. 
 
 
 [1]: http://blog.nguyenvq.com/2013/04/06/guide-to-accessing-ms-sql-server-and-mysql-server-on-mac-os-x/

diff --git a/odbc_setup_macos.md b/odbc_setup_macos.md
@@ -13,6 +13,7 @@ FreeTDS needs to be configured, so edit your freetds.conf in /usr/local/etc/ or
     nano ~/.freetds.conf
 
 Under **# A typical Microsoft server** you'll see *host*, *port*, and *tds version* variables. These and these only should be set.
+
     host = myserver.company.com
     port = 1433
     tds version = 7.2 (for MS SQL 2008)

diff --git a/odbc_setup_macos.md b/odbc_setup_macos.md
@@ -16,6 +16,8 @@ Under **# A typical Microsoft server** you'll see *host*, *port*, and *tds versi
     host = myserver.company.com
     port = 1433
     tds version = 7.2 (for MS SQL 2008)
+
+asdfasdf
 
 
 [1]: http://blog.nguyenvq.com/2013/04/06/guide-to-accessing-ms-sql-server-and-mysql-server-on-mac-os-x/

diff --git a/odbc_setup_macos.md b/odbc_setup_macos.md
@@ -6,8 +6,16 @@ On mac os, there is a default ODBC manager, iODBC. Other Unix based systems tend
 
 Start by installing freeTDS libraries. FreeTDS allows unix programs to talk natively to MS SQL and SyBase databases.
 
-  brew intsall freetds
+    brew intsall freetds
 
+FreeTDS needs to be configured, so edit your freetds.conf in /usr/local/etc/ or ~/.freetds.conf
+
+    nano ~/.freetds.conf
+
+Under **# A typical Microsoft server** you'll see *host*, *port*, and *tds version* variables. These and these only should be set.
+    host = myserver.company.com
+    port = 1433
+    tds version = 7.2 (for MS SQL 2008)
 
 
 [1]: http://blog.nguyenvq.com/2013/04/06/guide-to-accessing-ms-sql-server-and-mysql-server-on-mac-os-x/

diff --git a/odbc_setup_macos.md b/odbc_setup_macos.md
@@ -2,7 +2,12 @@ Since I spent essentially two full days figuring out how to access a corporate M
 
 These instructions and the commands that follow, were executed on a MAC OS 10.8.3 system. Additionally, I found this blog [post][1] especially helpful during the debugging process. 
 
-On mac os, there is a default ODBC manager, iODBC. Other Unix based systems tend to use [unixODBC][2]. Look elsewhere for a discussion about the differences between these diver manager. The only feature we care about is being able to connect to SQL databases through [pyodbc][3], and at the time of this writing, the
+On mac os, there is a default ODBC manager, iODBC. Other Unix based systems tend to use [unixODBC][2]. Look elsewhere for a discussion about the differences between these diver manager. The only feature we care about is being able to connect to SQL databases through [pyodbc][3], and at the time of this writing, the pyodbc requires iODBC as its manager. 
+
+Start by installing freeTDS libraries. FreeTDS allows unix programs to talk natively to MS SQL and SyBase databases.
+
+  brew intsall freetds
+
 
 
 [1]: http://blog.nguyenvq.com/2013/04/06/guide-to-accessing-ms-sql-server-and-mysql-server-on-mac-os-x/

diff --git a/gistfile1.md → odbc_setup_macos.md b/gistfile1.md → odbc_setup_macos.md
diff --git a/odbc_setup_macos → gistfile1.md b/odbc_setup_macos → gistfile1.md
diff --git a/odbc_setup_macos b/odbc_setup_macos
@@ -5,7 +5,6 @@ These instructions and the commands that follow, were executed on a MAC OS 10.8.
 On mac os, there is a default ODBC manager, iODBC. Other Unix based systems tend to use [unixODBC][2]. Look elsewhere for a discussion about the differences between these diver manager. The only feature we care about is being able to connect to SQL databases through [pyodbc][3], and at the time of this writing, the
 
 
-
 [1]: http://blog.nguyenvq.com/2013/04/06/guide-to-accessing-ms-sql-server-and-mysql-server-on-mac-os-x/
 [2]: http://www.unixodbc.org
 [3]: https://code.google.com/p/pyodbc/
diff --git a/odbc_setup_macos b/odbc_setup_macos
@@ -2,7 +2,7 @@ Since I spent essentially two full days figuring out how to access a corporate M
 
 These instructions and the commands that follow, were executed on a MAC OS 10.8.3 system. Additionally, I found this blog [post][1] especially helpful during the debugging process. 
 
-On mac os, there is a default ODBC manager, iODBC. Other Unix based systems tend to use [unixODBC] [2]. Look elsewhere for a discussion about the differences between these diver manager. The only feature we care about is being able to connect to SQL databases through [pyodbc][3], and at the time of this writing, the
+On mac os, there is a default ODBC manager, iODBC. Other Unix based systems tend to use [unixODBC][2]. Look elsewhere for a discussion about the differences between these diver manager. The only feature we care about is being able to connect to SQL databases through [pyodbc][3], and at the time of this writing, the
 
 
 

diff --git a/odbc_setup_macos b/odbc_setup_macos
@@ -0,0 +1,11 @@
+Since I spent essentially two full days figuring out how to access a corporate MS SQL database pythonicly, I figured I should leave some notes, for future reference and to aid other souls looking to do the same.  
+
+These instructions and the commands that follow, were executed on a MAC OS 10.8.3 system. Additionally, I found this blog [post][1] especially helpful during the debugging process. 
+
+On mac os, there is a default ODBC manager, iODBC. Other Unix based systems tend to use [unixODBC] [2]. Look elsewhere for a discussion about the differences between these diver manager. The only feature we care about is being able to connect to SQL databases through [pyodbc][3], and at the time of this writing, the
+
+
+
+[1]: http://blog.nguyenvq.com/2013/04/06/guide-to-accessing-ms-sql-server-and-mysql-server-on-mac-os-x/
+[2]: http://www.unixodbc.org
+[3]: https://code.google.com/p/pyodbc/
No results found