I am using query that work fine but after that i migrate and linked the table to SQL Server 2014 the queries are not working.
I am using query that work fine but after that i migrate and linked the table to SQL Server 2014 the queries are not working.
Is it an UPDATE query or what?
not just select query.
did you select an index when you linked to SQL Server?
what do you mean by index. I don't know.
when you link to sql server through odbc you are prompted to identify the index (tho' I don't know about SS14). If you don't provide this, the query may not work
but SSMA don't asked me about any index. Also some of queries work and some of them are not.
Sorry, I'm out of ideas