The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
I'm in the process of moving my MySQL databases over to a new server and the Snitz database is proving problematic and I'm getting a HTTP:500 error after pointing the connection string to the new server's IP
The host has said..
Is there an easy fix for this editing the current connection string or is it a case of loading the ODBC 5.1 driver into the new server?
Here is my current connection string (important stuff edited out)
Thanks
The host has said..
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
Is there an easy fix for this editing the current connection string or is it a case of loading the ODBC 5.1 driver into the new server?
Here is my current connection string (important stuff edited out)
Code:
strConnString = "driver={MySQL ODBC 5.1 Driver};option=16387;server=000.000.00.000;user=edit;password=edit;DATABASE=edit;" '##MySQL w/ MyODBC v5.1Thanks
Postet den
first thing you need to ask them is what odbc version do they have available, AFAIK 5.5 is the MySQL version not the ODBC version, I think the latest ODBC is 5.3
ODBC 5.1 should connect to MySQL 5.5 so it is possible they are using another later odbc version
ODBC 5.1 should connect to MySQL 5.5 so it is possible they are using another later odbc version
Postet den
Do you ever get the feeling that you're going around in circles when talking to host tech support?
After asking the question twice now and them looking into the connection issue for seemingly hours, they have come back with ..
Yet MySQL ODBC 5.1 is stil available to use: https://dev.mysql.com/downloads/connector/odbc/5.1.html
Am I right in thinking that the following connection string willwork with the MariaDB ODBC 3.0 driver (if it is installed)...
Thanks
Edit: just corrected a typo
After asking the question twice now and them looking into the connection issue for seemingly hours, they have come back with ..
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 ->
Yet MySQL ODBC 5.1 is stil available to use: https://dev.mysql.com/downloads/connector/odbc/5.1.html
Am I right in thinking that the following connection string willwork with the MariaDB ODBC 3.0 driver (if it is installed)...
Code:
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 DriverThanks
Edit: just corrected a typo
Postet den
params are slightly different, I believe the following should work
"Driver={MariaDB ODBC 3.0 Driver};Server=localhost;UID=odbc_user;PWD=odbc_pw;DB=odbc_test;Port=3306" (port is optional I believe)
"Driver={MariaDB ODBC 3.0 Driver};Server=localhost;UID=odbc_user;PWD=odbc_pw;DB=odbc_test;Port=3306" (port is optional I believe)
Postet den
Thanks Huw, I've just corrected a typo in the string (2.0 should have read 3.0) but it still doesn't work which suggests that the MariaDB driver isn't installed or is incorrectly installed
Running setup.asp it is returning the following error:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I've put it back in the hands of our hosts so will await their response.
(The forums are still working ok as they're still running off the existing servers not the new one we're trying to move over to)
Running setup.asp it is returning the following error:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I've put it back in the hands of our hosts so will await their response.
(The forums are still working ok as they're still running off the existing servers not the new one we're trying to move over to)
Postet den
This is still ongoing, I have managed to get a connection string to connect to a test database on the new server but when trying to create tables it manages to create 8 tables and then errors out.
Using the same connection string to an existing db on the new server results in the setup.asp page saying that the database needs to be installed (it already is)
Is Snitz forum compatible with MySQL Server 5.5 ?
Using the same connection string to an existing db on the new server results in the setup.asp page saying that the database needs to be installed (it already is)
Is Snitz forum compatible with MySQL Server 5.5 ?