Open Query in MS SQL from MY SQL 1

[jchewsmith]

I am creating a view in SQL Server 2014 and using open query to link back to a query in MYSQL the dataset is over 100k lines and I keep getting time out issues from the MS SQL server. The view runs fine in MY SQL. Is there another way to do this?

Code sample:
Select *
FROM OPENQUERY (server, 'SELECT * FROM database.viewname AS New Name

 

[gbaughma]

It sounds like it's timing out packing up the mysql query and shipping it over to SQL.

I guess it depends on what you're trying to do. You could:
a) turn up the timeout value
b) Request a smaller dataset (i.e. "... FROM OPENQUERY (Server, 'SELECT * FROM database.viewname LIMIT 1000)" sort of thing... (trying to remember my mysql syntax...)

Just a couple of thoughts.


Just my $.02

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg