search

anxiousmodernman / teamdash

A platform for developing, scheduling, and viewing reports
0 stars 0 forks source link

Connect to MSSQL with pyodbc #1

Open anxiousmodernman opened 11 years ago

anxiousmodernman commented 11 years ago

http://www.codesynthesis.com/~boris/blog/2011/12/02/microsoft-sql-server-odbc-driver-linux/

anxiousmodernman commented 11 years ago

@trackrn6 Wait, are we making ourselves crazy to do this in an ubuntu environment?

If you can get the pip python package manager installed on windows, then pretty much every python library you want can get downloaded from there. PyCharm also runs great on Windows (at least on the Win7 box Jeff uses).

Do this: http://stackoverflow.com/questions/4750806/how-to-install-pip-on-windows

Then find a windows 8 specific ODBC configuration. Register your development data sources there and you just give pydobc.connect() the data source name.