I've answered my own (perhaps near-sighted) question:

The 2007 Office System Driver: Data Connectivity Components does install the provider for Microsoft.ACE.OLEDB.12.0.

I can now see it in my list of Providers.

I've executed...

Thanks so much for the detailed posting, JALVES.

I noticed...

You're the man!

Thanks so much - I really appreciate it.

-Simon

Just wanted to say a quick thanks your code, M V Jones - I was able to use it to get exactly what I needed in a much simpler and...

Doug:

I flipped a switch in the MySQL ODBC Connector (see pic attached) to allow transactions, and things seem to be working great now.

Thanks so much for helping me get started...

Doug:

Thank you very much for the help.

I wrote the following bit of code, to test:

INSERT OPENQUERY (MYSQL_OE_Dreamhost, 'SELECT WebAccountID, PromotionAbr, PeriodID, OfferID, Feedback, DateAdded FROM oe_dbo.WebFeedback')

VALUES (8,'PS2','PS2803',38,'This is super!','April 24...

Doug:

I am very interested in some of the processes you described in your post - most notably loading rows from SQL Server 2005 into MySQL tables, via SSIS, or a...

Great article - thanks for the terrific contribution, Paul.

I'm going to be able to use the article immediately to help me get data out to the people who need it...

Jim Dillon (2/21/2008)

---

I think what you're looking for is:

INSERT INTO [Linked Server Name].catalog.[my_sql_table_name] (my_sql_columns)

SELECT [MS SQL SERVER columns]

FROM [Your MS SQL SERVER table]

I believe you can use a three...

Jim:

Your post has been incredibly helpful - thanks so much.

I was in meetings yesterday that revolved around integrating live MySQL data from the web with a local MsSQL database. I...

Thanks, Damon, for this tasty bit of code - I like...

Matt Miller (1/16/2008)

---

Keeping the "don't split things unless there's a good reason to" discussion in mind - if you are implementing a 1-to-1 relationship, then yes - it can be...

Thanks for your feedback and input, Michael, I appreciate it.

Suppose that one of the 3 conditions you mentioned was true - say, for example that there was a row in...

I think that you need to JOIN your two tables, as such:

UPDATE s

SET s.src_long_description = c.text

FROM database.dbo.test s

INNER JOIN database.dbo.copy_text c

on S.[PRIMARY KEY] = c.[FOREIGN KEY]

WHERE c.pageName = '/service/extended_description/serviceA'

Where...

Retire!!

(I know that's what I'm looking forward to...) 😉