Viewing 15 posts - 1 through 15 (of 38 total)
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
January 13, 2010 at 1:34 pm
Also, did you enable oledbconnections in your sql2005 surface area config?
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
January 13, 2010 at 10:10 am
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
January 13, 2010 at 10:04 am
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
January 13, 2010 at 9:41 am
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 = N'MYSQLLINKEDSERVERNAME', @srvproduct=N'SYSTEMDSNNAME',...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
January 13, 2010 at 9:23 am
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
January 13, 2010 at 9:02 am
When you map your user name and password, it has to be a user in the MySQL instance.....
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
January 13, 2010 at 8:48 am
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
December 21, 2009 at 4:37 am
Have you tried running an "OpenRowset" query over your linked server?
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
November 4, 2009 at 1:44 am
Check out this link:
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 @Result =...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
November 3, 2009 at 1:48 pm
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
November 3, 2009 at 8:54 am
Can you script out your Linked server and post it here please (* out any passwords...)
Which ODBC conector are you using?
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
November 3, 2009 at 8:50 am
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
November 3, 2009 at 8:36 am
If you run "SHOW PROCESSLIST" on your mysql server, can you see the SQL server connection?
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
November 3, 2009 at 8:10 am
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
August 12, 2009 at 3:04 pm
Viewing 15 posts - 1 through 15 (of 38 total)