Holiday Notice – Support Unavailable on April 18 and April 21

We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!

In the meantime, if you need any help, feel free to:

Amelia YouTube Channel

wpDataTables YouTube Channel

Thank you for your understanding, and we wish you a wonderful holiday weekend!

Okay
  Public Ticket #2799259
Need to connect to NexusDB database using ODBC
Closed

Comments

  • Prateek Singh started the conversation
    June 10, 2021 at 2:46pm

    I need to connect to NexusDB database using ODBC.  Information about the NexusDB database can be found at NexusDB.com.   I have ODBC drivers setup and can access the database using Microsoft Excel.  How can I connect using your plugin?

  • [deleted] replied
    June 10, 2021 at 3:19pm

    Hi Prateek

    Thank you for reaching out to us.

    Unfortunately we don't have a native integration with NexusDB, also for MSSQL the minimum required version is 2012 onward and they seem to use 2003 on their servers so we are not sure if this will work.

    For wpDataTables to successfully connect to separate databases, please make sure that you have these drivers installed and enabled on the server where your WordPress site is:

    3838527468.png

    From your response, it seems that ODBC is installed, but can you please check your info.php file, and see what the PDO section shows? If it's not the same as in the screenshot above, you'll need to install those drivers as well.

    Please have a look at this thread as well

    https://www.devart.com/odbc/nexusdb/docs/php.htm

    You can test the connection on our sandbox site and see if it will work, simply fill in the information and click on Test connection button

    6164827078.png