Connecting to Microsoft Access database

General
, ,
1

I want to be able to connect from R to a Microsoft Access database (.accb) from Ubuntu.

I've read this related question and gone through the answers but I couldn't make it work "I have a use case where one of the developer was trying to query a MS Access database (extension .accdb). " How can we read from access database on R Studio Server Pro?,

I am using unixODBC 2.3.4 and my /etc/odbcinst.ini is:

[PostgreSQL ANSI]
Description=PostgreSQL ODBC driver (ANSI version)
Driver=psqlodbca.so
Setup=libodbcpsqlS.so
Debug=0
CommLog=1
UsageCount=1

[PostgreSQL Unicode]
Description=PostgreSQL ODBC driver (Unicode version)
Driver=psqlodbcw.so
Setup=libodbcpsqlS.so
Debug=0
CommLog=1
UsageCount=1

[SQLite]
Description=SQLite ODBC Driver
Driver=libsqliteodbc.so
Setup=libsqliteodbc.so
UsageCount=1

[SQLite3]
Description=SQLite3 ODBC Driver
Driver=libsqlite3odbc.so
Setup=libsqlite3odbc.so
UsageCount=1

[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.4.so.2.1
UsageCount=1

However when I test some connections I see some error messages on the test cases. What I am missing?

2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.