Here's my situation. I have two databases on SQL Server and one MySQL (see details below). I've used myODBC to create a System DNS to the mySQL database on the Windows server. I've created a link using OLEDB for ODBC to create a linked server to MySQL. The link allows me to view a list of all the tables but now how do I view the data in a particular table?
What is the syntax to query a linked server? I've tried using the four part name in a query (select * from linkname...tablename) and received the following error,
Server: Msg 7356, Level 16, State 1, Line 3
OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
Any help would be greatly appreciated, thanks!
OS: Windows 2000 Server.
DB: SQL Server 2000.
OS: OpenBSD v2.9 i386.
DB: MySQL Database v8.19 Distrib 3.23.37.