In reference to the error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. That error means that the Data Source Name (DSN) you are specifying in your connection configuration is not being found in the windows registry. It is important that your ODBC driver’s executable and linking format (ELF) is … Read more
Causes General error Unable to open registry key Temporary (volatile) Ace DSN for process … This is the top-level error message produced by the Access Database Engine (a.k.a. “ACE”) ODBC driver when the current process is unable to open the Access database file for one of the following reasons: Some other process has opened the … Read more
There are several configuration files you need to have set up. /etc/odbc.ini, /etc/odbcinst.ini and /etc/freetds/freetds.conf (these locations are valid for Ubuntu 12.04 and probably correct for most *nixes). You’ll need to install unixodbc and freetds (not sure what the package names are on CentOS). In Ubuntu this would be apt-get install unixodbc tdsodbc. For help … Read more
What causes this error? The error message tells you, simply put, that the ODBC Driver Manager could not find the driver you specified in your connection string or DSN. This can have 3 common causes: The driver you tried to use is not installed on your system The driver is installed, however, it doesn’t match … Read more
On Mac OSx and Ubuntu 18.04 you can use pandas_access From the documentation: import pandas_access as mdb db_filename=”my_db.mdb” # Listing the tables. for tbl in mdb.list_tables(db_filename): print(tbl) # Read a small table. df = mdb.read_table(db_filename, “MyTable”) On Ubuntu you may need to run: sudo apt install mdbtools
Problems with character set are quite common, let me try to give some general notes. In principle you have to consider four different character set settings. 1 and 2: NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET Example: AL32UTF8 They are defined only on your database, you can interrogate them with SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER IN (‘NLS_CHARACTERSET’, ‘NLS_NCHAR_CHARACTERSET’); … Read more
At this point in your code you have only connected to your database. Please look at an example here in stackoverflow that may help you to see what your next steps could be (it refers to MySQL but it is still instructive): Perl inserting into MySQL DB Also, I would recommend what user Matt Jacob … Read more