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?
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:
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.
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?
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:
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