MySQL Forums
Forum List  »  Microsoft SQL Server

Once Again 4-part Queries are failing with linked Server
Posted by: Randy Pitkin
Date: August 22, 2012 02:02PM

A recent and complete rebuild of my MSSQLServer and Latest Version of MySQL ODBC is failing to connect to External MySQL Server

That is, a query like:

SELECT * FROM [TRACKER]...[issues]
SELECT * FROM [TRACKER].[bitnami_redmine]..[issues]
worked prior to this migration, but now issues the following error:

Msg 7313, Level 16, State 1, Line 1
An invalid schema or catalog was specified for the provider "MSDASQL" for linked server "TRACKER".

SELECT * FROM OPENQUERY([TRACKER], 'SELECT * FROM Issues')
Returns Expected Results

Tried
SELECT * FROM [TRACKER]..[bitnami_redmine].[issues]
A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

In forums, I have scene and added "option=3" to the connection string but I do not know what that option refer too.

Options: ReplyQuote


Subject
Written By
Posted
Once Again 4-part Queries are failing with linked Server
August 22, 2012 02:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.