December 5, 2008 at 2:01 pm
I have created a linked server to a MySQL database.
I have created views that display all of the table data.
Unfortunately, I cannot update the data through the views.
What are the options for updating, adding and deleting data across a linked server?
Is there a way to create tables in the database that have data in them that is live on the MySQL table and not just a copy there of?
It's funny that in MS Access, which is supposed to be a lesser application, you can link tables that are in a MySQL database.
The links show up as tables.
You can physically change data in a table and have it be reflected in the MySQL table, and you can run adds, updates and deletes against the links.
December 5, 2008 at 2:34 pm
Can you post the properties for the linked server?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 5, 2008 at 2:39 pm
I have a SQL Server with several MySQL instances as linked servers and I can do all the standard CRUD operations on them without a problem. I would hazard a guess its either a permissions issue, a lack of a primary key or something similar.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply