Create a DSN in the odbc.ini file

Linux DSN Configuration

After the linux (DEB or RPM) driver is installed, a DSN with the name DEVART_MSACCESS is created. You can use it to test the connection with the MSACCESS server. For this, perform the following steps:

1. Open the odbc.ini file located in the /etc folder. Find the DEVART_MSACCESS section and specify the required connection settings:

   
       User ID=<your Microsoft Access user name>
       Password=<your Microsoft Access password>
       Server=<your Microsoft Access server address>
       Port=<your Microsoft Access port>
       Database=<your Microsoft Access database name>
       
   

2. Run the UnixODBC Test Command utility and test a connection using the following command:

   isql -v DEVART_MSACCESS 

   

See Also

Connection Options