July 22, 2010 at 2:23 pm
i have the link server set up properly and had the select correct however got sidetraked and lost my query that worked and dont recal how i got it to work.
here's what i have now
select *
from openquery(
LOCALXML_PROD,
'select * from [localxml]..[claimed_business_record]'
)
the linked server name = LOCALXML_PROD
does anyone see any obvious syntax errors. i get the below error:
OLE DB provider "MSDASQL" for linked server "LOCALXML_PROD" returned message "[MySQL][ODBC 3.51 Driver][mysqld-5.1.36-community-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[localxml]..[claimed_business_record]' at line 1".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSDASQL" for linked server "LOCALXML_PROD".
July 22, 2010 at 2:29 pm
nevermind i got it. no .. between db and table, no brakets and case sensative
'select * from localxml.claimed_business_record'
June 7, 2012 at 11:09 am
This is the only place I found this solution!!! I had the excat same problem and you saved my day!!!
Very much appreciated.
Thanks you
John
January 10, 2013 at 2:16 am
It has worked. Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply