We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

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