Can IBProvider Free Edition work with Linked Server?
No, Free IBProvider can't work with linked server in MSSQL
Use LCPI.IBProvider.3 for obtain a maximum comfort in work with Firebird and Interbase through MSSQL Linked Servers.
You can use LCPI.IBProvider.3.Lite also. But you can get degradation of performance for modifying operations (insert, update and delete) - MSSQL will use a "Client Cursor Engine", and unexpected problems with them.
So, we recomend to use LCPI.IBProvider.3
What is the valid connection string to the linked server?
Add the following parameters into the connection string:
More connection string parameters here:
http://www.ibprovider.com/eng/documenta ... y_001.html
Database location ("data source" or "location") must contains server name or 'localhost' (server_name:server_path_to_database_file)
What SQL syntax can i using for Linked Server?
SQL queries in SQL Management Studio must be compatible with Transact SQL
What do I need to do if I have found a bug?
Before report about any error please read this article:
If you will find a bug please send report which contains:
1. IBProvider version (see file properties)
2. IBProvider filename
3. OS version (WinXp, Win 200, Vista ...)
4. MSSQL version
5. Interbase/Firebird version
6. Database charset by default
7. Metadata of tables (include information about charsets of columns)
8. SQL query.
9. Error message text or screenshot
This will save your and our time.