Can an Interbase server be linked as a linked server to an MS SQL 2008 server
Posted on 2015-01-19
I'm an access developer with some MS SQL developer experience. I've run into a situation where the client's query on his access database are running very slow. This query is based on 3 linked MS Sql queries (located in the MS SQL server) and one linked query located on an Interbase database. Needless to say, since the query is being executed on the MS Access front-end, it is very slow. Is there a way to set up the Interbase server as a linked server on the MS Sql server. If so, what considerations do I need to take into account.