Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import os
- import sys
- import time
- import pyodbc
- LOCATION = "c:\Users\USERNAME\Desktop\DATA\ScorMonitor.db"
- cnxn = pyodbc.connect(r"DRIVER={Microsoft Paradox Driver (*.db)};UserCommitSync=Yes;PageTimeout=5;axScanRows=8;MaxBufferSize=2048;FIL={Microsoft Paradox Driver};DriverId=25;DefaultDir=C:\Users\USERNAME\Desktop\3s\DATA;DBQ=C:\db1.db".format(LOCATION), autocommit=True, readonly=True)
- cursor = cnxn.cursor("")
- cursor.execute("select last, first from test")
- row = cursor.fetchone()
- print row
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement