Glad it helped!

From memory, that issue can be fixed by turning off one of the settings in the MySQL ODBC driver (I think related to Transactions...) [Sorry, I don't have access currently...

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...

Hi,

I'm a newbie to this forum, so please be gentle with me 😎

Great (original) post that was really helpful to me in getting started, but...

I am trying to...