Hi all I am new to the forum as well as this fantastic app. But the short is I am having a few problems trying to setup VRS to communicate with my MySQL server. I have created a ODBC connection under Control Panel>Admin Tools>Data Services and have installed MySQL ODBC 3.51 Driver set that up to communicate with my databse, tested works fine.
My problem is, when I go into the Options on VRS Database>Database and Table Selection, from the Database to Insert Into field I have selected the DSN which I created and then supple the username and password used to login to my database.
Once I click on Test Login Details I get a error message saying something along the lines of database details are incorrect or the database server has an active connection. Neither of these to my knowledge is possible as I have used the same details which I used for the DSN to create the ODBC connection and there are no other connections to my database.
Has anyone had this issue before? I did do a search before I posted this, some issues were similar but none that matched my problem. Appologies if I did not look hard enough however.
Any help would be great!