Home Forums SQL Server 2012 SQL 2012 - General Create Linked Server for firebird RE: Create Linked Server for firebird

  • January 26, 2015 at 6:57 am

    #1773089

    you say you installed the firebird odbc, but the error message clearly says you are using MSDASQL and not LCBI.IBProvider.3, so offhand, i'd say you should script your linked server so we can see the settings you have for it.

    for every linked server i've ever set up, i've ALWAYS had to set the two properties AllowInProcess and DynamicParameters for the driver: they are never the right values by default.

    for example:

    EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1

    GO

    EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1

    this web site has some nice screenshots on usign the GUI to set up a firebird connection/linked server:

    http://www.ibprovider.com/eng/documentation/mssql_2012.html

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!