Configure Datacore in Stata in iOS

1. Download Software
   • To download software you must be on osuwireless
   • Download Homebrew and x-code
     • Into a terminal paste:

ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

• Download unixodbc libraries
  • Into a terminal paste:

brew install unixodbc

• Download freetds libraries
  • Into a terminal paste:

brew install freetds

2. Alter ODBC files.

• Navigate to /usr/local/etc/
  • alter odbc.ini Paste:

[MYDSN]

Driver = FreeTDS

Server = 10.127.24.117

Port = 2408

• alter odbcinst.ini Paste:

[FreeTDS]

Driver = /usr/local/lib/libtdsodbc.so

3. Connect to the database in STATA

• Use unixodbc in STATA
  • Type into stata:

set odbcmgr unixodbc

• query a test table in SQL while connected to OSUWMC
  • Type into stata:

odbc load, dsn("MYDSN") user("test") password("test") exec ("select * from CAT1.dbo.shreadraw")

If data populated into stata, then the connection is successful.