| 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. |
| # | Content |
|---|---|
| 1 | ## 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() |