How to create linked server in sql server with firebird?

Question

SQL

Guys with experience please share. How to create linked server in sql server with firebird? I found the instruction www.ibprovider.com/rus/documentation/mssql_2012.ht... True, not everything is clear. Questions
1: Is the bit depth of servers important, ie. should they be the same or does it not matter? What about versions?
2nd: In paragraph 2 of the instruction, you need to install the client that you need? If you can link, which one.
3rd: In paragraph 5 of the instruction, there is the MSDTC service. Where to find it?
4th: What settings should be added to the Provider String when creating the server? are there any nuances?

Answer 1

I once did it through the ODBC driver, but I ran into a problem when the FB database structure was in upper case, there were problems with queries. plus not all requests work. as a result, I had to overtake the data through navicat.
for your questions.
1) bit depth is important
2) meaning that you have ms sql and fb on different servers, you need to install the fb client on the server with ms sql so that ibprovider can connect.
3) to the server with ms sql, the service "Distributed transaction coordinator"
4) it all depends on your database