Python Forum
Python Forum

Why do I get this error when I try to access MSAccess database from python?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Why do I get this error when I try to access MSAccess database from python?
nilamo
Last Thursdayist
Super Moderators
Posts: 3,458
Threads: 101
Joined: Sep 2016
Reputation: 143
#2
Aug-09-2017, 08:35 PM
Because you need to supply a data source name when using odbc.  Other connectors use a file name (sqllite), or an ip address to connect to (...any other connector).  Otherwise, how is the library supposed to know which database you're trying to connect to?
Find
Reply


Messages In This Thread
RE: Why do I get this error when I try to access MSAccess database from python? - by nilamo - Aug-09-2017, 08:35 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  access is denied error 5 for network drive mapping ? ahmedbarbary 2 1,862 Aug-17-2022, 10:09 PM
Last Post: ahmedbarbary
  Server Folder Error : WinError5 Access Denied fioranosnake 1 1,172 Jun-21-2022, 11:11 PM
Last Post: Larz60+
  error 1102 (42000) incorrect database name 's' Anldra12 4 1,759 Jun-08-2022, 09:00 AM
Last Post: Anldra12
  mySQL Database error not resolving. cybertooth 2 3,287 Aug-30-2021, 05:45 PM
Last Post: ibreeden
  Error creating database with python and form? shams 3 2,413 Aug-02-2021, 02:00 PM
Last Post: deanhystad
  Can't access the net using Python's Selenium module ShishirModi 2 2,103 Jul-21-2020, 06:03 AM
Last Post: ShishirModi
  Python for MS Access DB Kundan 0 1,908 Feb-20-2020, 08:27 AM
Last Post: Kundan
  Access list items in Python kamaleon 2 2,408 Dec-31-2019, 11:10 AM
Last Post: kamaleon
  Error in Database connectivity with python3.7 srm 8 4,603 May-13-2019, 07:28 AM
Last Post: srm
  How retrieve sqlite3 database saved image and access in python3 tao01 1 2,495 Dec-22-2018, 09:04 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020