Sorry, my mistake -

Is there anything in the MySQL server app or security log? What happens if you try to expand the catalogs in the linked server?

Is Excel or...

Also, did you enable oledbconnections in your sql2005 surface area config?

Tricky without being able to see it, but add a host of % to your user - it may be resolving the DNS name in this driver, or adding the...

Is your MySQL server instance listening on port 3306, and does the remoteacct user have '%' access? (As in access from anywhere)? And access to that database?

And now for daft...

OK,

If you right click on your linked server and choose to script it to new window, does the "EXEC master.dbo.sp_addlinkedserver" line look similar to this:

EXEC master.dbo.sp_addlinkedserver @server =...

In an example of one that I have working, I didn't map local login/Impersonate/Remote User etc at all. Try removing that user you have there and in the bottom half...

When you map your user name and password, it has to be a user in the MySQL instance.....

Another thought - this isn't the same as my issue is it? As in is it 64 bit SQL Server connecting to 32 bit MySQL?

There is no 64 bit MySQL...

Have you tried running an "OpenRowset" query over your linked server?

Check out this link:

http://support.microsoft.com/kb/959031"> http://support.microsoft.com/kb/959031

Also, try this on the SQL server:

CREATE PROCEDURE [sp_tables_info_rowset_64]

@table_name sysname

, @table_schema sysname = NULL

, @table_type nvarchar(255) = null

AS

DECLARE @Result int

SELECT...

Oh, and a thought:

If you right-click on the linked server, choose properties and click "security" in the left pane, at the bottom do you have "Be made using this security...

Can you script out your Linked server and post it here please (* out any passwords...)

Which ODBC conector are you using?

Shouldn't be.

If you can only see the local connection in your processlist, then the linked server isn't making a connection.

If you run management studio, expand server objects, linked servers, and...

If you run "SHOW PROCESSLIST" on your mysql server, can you see the SQL server connection?

Hi - its late and I'm not making much sense - been a VERY long day 🙂

I am trying to pull data from a MySQL instance living on a Windows...