Once Again 4-part Queries are failing with linked Server
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.
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.