aioodbc_async_microsoft_access_dsn_less_connection_query.py

1import asyncio
2import aioodbc
3
4
5async def test_example():
6    dsn = 'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=c:\\path\\to\\database.accdb;'
7    loop = asyncio.get_event_loop()
8    conn = await aioodbc.connect(dsn=dsn, loop=loop)
9
10    cur = await conn.cursor()
11    await cur.execute("SELECT 1")
12    r = await cur.fetchone()
13    print(r)
14    await cur.close()
15    await conn.close()
16
17
18loop = asyncio.get_event_loop()
19loop.run_until_complete(test_example())