Linux DSN Configuration - ODBC Driver for BigCommerce

Linux DSN Configuration

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

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

   
   
   User ID=<your BigCommerce User Name for Basic Authentication>
   Authentication=<your BigCommerce authentication type: Basic or OAUTH>
   Store ID=<your BigCommerce Store ID for Basic Authentication>
   Client ID=<your BigCommerce Client ID for Basic Authentication>
   API Version=<Ver3; Protocol Ver 3+ Auth option>
   Access Token=<your BigCommerce Access Token for Basic Authentication>
   Authentication Token=<your BigCommerce Authentication Token for OAUTH>
   Server=<your BigCommerce server address for Basic Authentication>
   

   Please see the Basic and OAUTH authentication types examples below:

   Basic

   

   OAuth.

   

   For Protocol Ver 3+ Auth, add another option

   API Version=Ver3

   

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

   isql -v DEVART_BIGCOMMERCE 

   

See Also

Connection Options