Linked MySQL Table no longer working in Microsoft SQL
I have a Microsoft SQL Server that we linked a MySQL DB to a few months ago, it had been working properly, but in the last two weeks we have not been able to access the table as before.
We started receiving the following error in Microsoft SQL Server Management Studio 2016:
I have updated the MySQL ODBC driver to the current version (5.3.9 as of Sept 2017) - recreated the linked table and still receive the same error.
Here are my settings on the Linked DB:
On the provider Options I have the following boxes checked - Nested Queries - Level Zero Only - Allow Inprocess
The rest are not checked
The ODBC Connection is set up - it worked before, and when you test the connection it returns a successful connection.
I recreated the connection and started getting another error, similar to this one, but it was referring to the credentials not being correct. I went into the security tab on the linked table and added our windows service account, and then had it present as the user connecting to the MySQL table and the connection is now working properly. I also found that on the set up I put in MSDASQL as the data source.
I am not sure what I did to correct the issue, but it is now working and the end users can run queries against the linked table now.
- MySql can't make column auto_increment
- Insert auto increment primary key to existing table
- 3 mysql table join but not getting expected result that i want
- MySQL insert_id returning null even though there was an insert
- mysql select query within a serialized array
- MySQL: Large VARCHAR vs. TEXT?
- php_network_getaddresses: getaddrinfo failed error in Docker's adminer
- Correlated queries - In derived tables, can I have many nesting levels?
- Is there a MySQL option/feature to track history of changes to records?
- When is a database called as an Embedded database?
- Multiple foreign keys from one table to same field in another table in Laravel
- Datetime-value's time inserted incorrectly in one column but not in another MYSQL
- Syntax diagrams for MySQL
- Converting currency symbols '$' '£' to html code $ £?
- Create Index in mysql not working
- Incorrect string value: '\xEF\xBF\xBD' for column
- Understanding inner join in recursive CTE (MySQL)
- Update MySQL table with rank number of duplicates by name
- Mysql query for 3 tables & user meta
- Setting up new instance of MySQL what is Current Root Password?
- How to change the CHARACTER SET (and COLLATION) throughout a database?
- How to resolve circular foreign key constraints with NOT NULL in Hibernate
- mysql join to record first one which is not matched before
- Conditional statement in migration doesn't work laravel
- Mysql ERROR at line 1153: Unknown command '\'
- How do I find the command causing a replication error in MySQL
- Wordpress Meta Value (Serialized) Filter
- Can you access the auto increment value in MySQL within one statement?
- Can't connect to RDS instance from EC2 instance
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)