Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kyma
Starting Member
11 Posts |
 Posted - 2008-07-25 : 07:54:54
|
| I'm having some problems with setting up triggers to update a MySQL database. My code is:create trigger items_insert on [dbo.names]Where 'names' is the name of the table I am trying to link.On execution, I receive the error:the object 'dbo.names' does not exist or is invalid for this operation.If you have the time to help with this, I would be very grateful. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-25 : 08:00:18
|
| Are you on a SQL Server trying to link to MySQL or are you completelty on MySQL?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
kyma
Starting Member
11 Posts |
Posted - 2008-07-25 : 08:14:58
|
| I'm on sql server, with MySQL also installed on the same server |
|
|
|
kyma
Starting Member
11 Posts |
Posted - 2008-07-25 : 10:30:16
|
| Some further information:I'm working on a project that links an MSSQL Server with a MySQL database for web publishing. I have set up an ODBC DNS profile for the MySQL and have then used this to set up a linked server from within SQL Server Management Studio. Then I have set up sql triggers that should push the data into the MySQL, whenever the MSSQL is updated. When I try to execute these triggers, they time out, returning the message:Named Pipes Provider: Could not open a connection to SQL Server |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-26 : 19:04:54
|
| Then you should put trigger on sql table, push data to MySql table via linked server in the trigger. |
|
|
|
|
|
|
linked server triggers