Create Linked Server for firebird

Question

Create Linked Server for firebird

amigoface

SSC Eights!

Points: 991
More actions
January 26, 2015 at 5:17 am

#314064

Hi,
i didn't figure out how to add a firebird linked server via ODBC
my system :
win 7 pro 64
SQL server 2012 express 64
firebird 2.5.3 64
Official ODBC drivers 64
i have created the odbc source without problem, and checked that in visual studio and ssms import data wizard , both show me the data from firebird database
but when i try to create a linked server , i have something like this message (the image is from the web)
as you can guess , any help is more than welcome 😉

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

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!

amigoface SSC Eights! Points: 991 More actions · Answer 2

i am not using the ibprovider but the ODBC provider from here

http://www.firebirdsql.org/en/odbc-driver

and everything is 64bits

so i have created an odbc datasource with odbcad32 which is in SysWOW64 Windows folder , check that it work with visual studio .

and then tried to add a linked server :

here is my setup :

and like said before i have this error message

The data source (DSN) has specified an architecture mismatch between the driver and the application error code 7303

what i am missing here ?

Lowell SSC Guru Points: 323518 More actions · Answer 3

i guess i was expecting to see a different driver, and it should be the one that is specific to firebird, and not the microsoft driver:

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!

amigoface SSC Eights! Points: 991 More actions · Answer 4

finally i have used ibprovider, i didn't know that there is a "lite" free version . (maybe and hopefully it's enough for me)

first try and everything work like expected :w00t:

now the real fun begin with tests to see if everything is ok . 😉

thanks a lot !