Peter J. Boettcher — Wed, 25 Sep 2002 13:14:20 +0000

Not really. Have you used a linked mySQL database successfully before? Maybe there is a bug in the ODBC driver.

openquery() sounds like it would add a lot of extra overhead but I think in some cases it is actually faster (because of the way SQL Server interprets and returns the data) than four-part naming.

The Warden — Tue, 24 Sep 2002 14:41:32 +0000

I have the link created successfully but can only see a list of tables but not the content of a table. I created the link using the GUI (Enterprise Manager). I would assume it uses the sp_addlinkedserver. Like I stated above in the previous message, I'm trying to figure out how to query the linked server using the four part name (ex. servername...tablename). So far I've be unsuccessful. I did recently get openquery() to work but I would prefer to use the four part name. Using openquery() in my situation would create a lot of overhead considering in most cases that I woul have 1 query with 2 embedded queries (3 levels). This method doesn't make sense to me and makes more sense to go direct.

Any ideas?

Quote: Originally posted by Peter J. Boettcher
I have never linked to a mySQL db but I have had problems in the past linking to an Access db that wasn't on the same machine or mapped.

Have you linked the databases inside SQL Server (sp_addlinkedserver) ?

Peter J. Boettcher — Mon, 23 Sep 2002 23:35:23 +0000

I have never linked to a mySQL db but I have had problems in the past linking to an Access db that wasn't on the same machine or mapped.

Have you linked the databases inside SQL Server (sp_addlinkedserver) ?