It seems like only a single backslash is shown. The database is on a network-storage.ĮDIT: in the connection-string, the backslashes should be double backslashes. This is my connection string which fails with above mentioned error: conn = nnect('Driver= Provider=.4.0 Password=mypassword User ID=myusername dbq=\\fileserver\\conta\\locationdir\\mydatabase_be.mdb Persist Security Info=True Jet OLEDB:System database=\\FILESERVER\\backend\\mdw\\system.mdw')Īs you can see, this connection requires to use a System database (workgroup - mdw).
When your Access data changes, you can easily refresh the data in Excel. Select a table on the left side of the Navigator window and click Load. I keep getting the following error: pyodbc.Error: ('IM002', ' Data source name not found and no default driver specified (0) (SQLDriverConnectW)') Click From Database, From Microsoft Access Database. In a Python script with pyodbc, I am trying to connect to a still used Access 97 database on our network but I have problems to get the connection (or the connection string) to work.
0 kommentar(er)
