quote:

---

it looks like because your previous MYSQL version was 5.1 and the new one is 5.5 that the connection information you are using is not supported

---

strConnString = "driver={MySQL ODBC 5.1 Driver};option=16387;server=000.000.00.000;user=edit;password=edit;DATABASE=edit;" '##MySQL w/ MyODBC v5.1

quote:

---

Thank you for your patience, I have looked into your query and the new VPS currently uses MariaDB ->

+-------------------------+---------------------+
| Variable_name | Value |
+-------------------------+---------------------+
| innodb_version | 5.5.52-MariaDB-38.3 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.56-MariaDB |
| version_comment | MariaDB Server |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+---------------------+

We wouldn't be able to install the depreciated ODBC driver 5.1 however we may be able to install the MariaDB driver ->

---

strConnString = "driver={MariaDB ODBC 3.0 Driver};option=16387;server=00.00.00.00;user=edit;password=edit;DATABASE=db_name;" '##MySQL w/ MariaDB ODBC 3.0 Driver

quote:

---

Error Description :
Specified driver could not be loaded due to system error 5: Access is denied. (MySQL ODBC 5.3 ANSI Driver, C:\Program Files (x86)\MySQL\Connector ODBC 5.3\myodbc5a.dll).

---

quote:

---

New Server:
+-------------------------+---------------------+
| Variable_name | Value |
+-------------------------+---------------------+
| innodb_version | 5.5.52-MariaDB-38.3 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.56-MariaDB |
| version_comment | MariaDB Server |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+---------------------+
7 rows in set (0.00 sec)

Old Server

+-------------------------+---------------------+
| Variable_name | Value |
+-------------------------+---------------------+
| protocol_version | 10 |
| version | 5.1.73-log |
| version_comment | Source distribution |
| version_compile_machine | x86_64 |
| version_compile_os | redhat-linux-gnu |
+-------------------------+---------------------+
5 rows in set (0.00 sec)

---

quote:

---

Originally posted by Webbo

Post overlap

Will do Huw

---

quote:

---

Unfortunately, we are unable to install additional software onto the managed VPS platform and can only use what software components already exist on the system. An un-managed VPS may be more suitable as you will have full root access to the system and you can install any components you wish to suit your needs.

---

quote:

---

The database needs to be installed !!


You need to create all the tables in the database before you can start using the forum.


Click here to create the tables in the database.

Click here to retry.

---

quote:

---

I've double checked everything and the ODBC driver is installer and external MySQL connections are enabled.

It's in the MySQL configuration file (/etc/my.cnf) ->

#bind-address = ::ffff:127.0.0.1
bind-address=0.0.0.0

Enabled in Plesk ->

====
Tools & Settings > Database Servers > Settings

"Allow remote connections from any host" is selected.
====

And we can log in externally from another server with that MySQL user ("myUID") to that database, and see tables and data there ->

=====
$ mysql -h server_IP -u myUID -p myPWD
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 90676
Server version: 5.5.56-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql [db_name]> show tables;
+--------------------------+
| Tables_in_db_name |
+--------------------------+
| list of tables
+--------------------------+
80 rows in set (0.00 sec)

mysql [db_name]>
=====


I'm afraid I don't know why that forum software has that issue, because server side here everything looks fine.

Are you able to speak to the developers of the software for any guidance or tips why this might be occurring? They may have come across this before.

---