Python/learning/SQL_odbc.py

## This is a file that shows how Python interacts with SQL.
#EBorges
#02.25.02

import dbi
import odbc

myconn = odbc.odbc('MW_repository')
mycursor = myconn.cursor()
mycursor.execute('SELECT NetLogin, NetUDrivePath FROM Employees')
mydata = mycursor.fetchall()
mycursor.close()
myconn.close()
Revision:	8
Committed:	Sat May 5 04:21:19 2012 UTC (13 years, 10 months ago) by ninoborges
Content type:	text/x-python
Original Path:	*Python/NinoCode/learning/SQL_odbc.py*
File size:	303 byte(s)
Log Message:	Initial Import
#	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()