Using OpenRowSet Transact SQL, I want to view/obtain data from MySql
using this function in "MS SQL Query Analyzer". Can I do this at all?
I have MyODBC driver and the relevant OLE DB provider to connect to
MySQL db, I can connect to MySQL db, but having problem with the last
parameter (table name) in the function. Query Analyzer reports the
following:
"A four-part name was supplied, but the provider does not expose the
necessary interfaces to use a catalog and/or schema."
SELECT a.*
FROM OPENROWSET('MSDASQL',
'DRIVER={MySQL ODBC 3.51 Driver};SERVER=LocalHhost;UID=root;PWD=test',
testdb.table1) AS a
regards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
