| Revision: | 591 |
| Committed: | Tue Nov 3 22:45:12 2015 UTC (10 years, 4 months ago) by nino.borges |
| Content type: | text/x-python |
| File size: | 303 byte(s) |
| Log Message: | Moved dir out of main dir. |
| # | User | Rev | Content |
|---|---|---|---|
| 1 | ninoborges | 8 | ## This is a file that shows how Python interacts with SQL. |
| 2 | #EBorges | ||
| 3 | #02.25.02 | ||
| 4 | |||
| 5 | import dbi | ||
| 6 | import odbc | ||
| 7 | |||
| 8 | myconn = odbc.odbc('MW_repository') | ||
| 9 | mycursor = myconn.cursor() | ||
| 10 | mycursor.execute('SELECT NetLogin, NetUDrivePath FROM Employees') | ||
| 11 | mydata = mycursor.fetchall() | ||
| 12 | mycursor.close() | ||
| 13 | myconn.close() |